1. Smith & Wesson

Smith & Wesson

686 PLUS DELUXE, 3-5-7 MAG, S/S SATIN, .357MAG .38SPL +P, 6IN, 7RND, DA/SA

Smith & Wesson 686 Deluxe 357 Magnum 7-Round/6-inch Revolver with Wood Grips (LE)

  • $1,019.00
In Stock
MP-15 TACTICAL 5.56 RIFLE

Smith & Wesson M&P-15 Tactical 5.56mm Semi-Auto Rifle

  • $1,159.00 $869.99
MP15 SPORT II 5.56MM MAGPUL WITH AIMPOINT

Smith & Wesson M&P15 Sport II 5.56mm with Magpul MOE M-LOK and Aimpoint PRO Patrol Optic

  • $1,268.00 $869.99
MP40 SHIELD M2.0 PC 40SW OR 4-INCH

Smith & Wesson M&P40 Shield M2.0 Performance Center 40 S&W Optics Ready with 4-Inch Barrel and Red

  • $883.00 $869.99
MP45 SHIELD M2.0 45ACP PC WITH RED DOT

Smith & Wesson M&P45 Shield M2.0 45 Auto Optics Ready Performance Center Pistol with 4 MOA Red D

  • $883.00 $869.99
MP9 M2.0 9MM PERFORMANCE CENTER PORTED WITH CRIMSON TRACE RED DOT OPTIC

Smith & Wesson M&P9 M2.0 9mm Performance Center Ported with Crimson Trace Red Dot Optic

  • $914.00 $869.99
MODEL 60 357 MAG PRO SERIES REVOLVER

Smith & Wesson Model 60 357 Magnum Pro Series Revolver

  • $899.00 $769.99
SW1911 CT E-SERIES 45 ACP STAINLESS

Smith & Wesson SW1911 CT E-Series 45ACP Stainless Pistol with Crimson Trace Lasergrips

  • $1,195.00 $859.99
MP 15 PATROL RIFLE BLACK 5.56 16IN 1-30RD MAG

Smith & Wesson M&P15 5.56mm NATO Patrol Rifle (LE)

  • $1,029.00
In Stock
SW1911ES E-SERIES 45ACP STAINLESS (LE)

Smith & Wesson SW1911ES E-Series 45 ACP Stainless Centerfire Pistol (LE)

  • $1,129.00
In Stock
MODEL 686 PLUS 357 MAGNUM 7-ROUND/6-INCH REVOLVER (LE)

Smith & Wesson Model 686 Plus 357 Magnum 7-Round/6-inch Revolver (LE)

  • $999.00
In Stock
69 COMBAT 44 MAG STAINLESS REVOLVER (LE)

Smith & Wesson Model 69 44 Magnum Stainless Combat Revolver (LE)

  • $999.00
66 .357MAG STAINLESS REVOLVER (LE)

Smith & Wesson Model 66 357 Magnum Stainless Revolver (LE)

  • $999.00
In Stock
686 PLUS 357 MAG (LE)

Smith & Wesson Model 686 Plus 357 Magnum 7-Round/3-inch Revolver (LE)

  • $999.00
686 PLUS 357 MAGNUM STAINLESS 7-SHOT/2.5-INCH REVOLVER (LE)

Smith & Wesson 686 Plus 357 Magnum Stainless 7-Shot/2.5-inch Revolver (LE)

  • $999.00
In Stock
MODEL 66 COMBAT MAGNUM, .375 MAG, .38 SPL +P, 2.75IN, 6RND, DA/SA

Smith & Wesson Model 66 Combat Magnum 357 Mag Double-Action Revolver (LE)

  • $999.00
In Stock
MODEL 69 COMBAT MAGNUM 44 MAG DOUBLE-ACTION REVOLVER (LE)

Smith & Wesson Model 69 Combat Magnum 44 Mag Double-Action Revolver (LE)

  • $999.00
629 CLASSIC 44 MAG 6.5 BARREL REVOLVER

Smith & Wesson Model 629 Classic 44 Magnum 6.5-Inch Revolver

  • $989.00 $849.99
<< < 13 14 15 16 17 > >>
Back to top

Debugging Information
ColdFusion Server Evaluation 2021,0,13,330286
Template /category.cfm
Time Stamp 20-May-24 02:56 PM
Locale English (US)
User Agent Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote IP 10.200.2.4
Host Name 10.200.2.4

Execution Time

Total Time Avg Time Count Template
2051 ms 2051 ms 1 E:/inetpub/wwwroot/category.cfm
1390 ms 1390 ms 1 E:/inetpub/wwwroot/category_sidenav_new.cfm
597 ms 597 ms 1 E:/inetpub/wwwroot/category_product_display.cfm
150 ms 8 ms 18 C:/inetpub/wwwroot/includes/qry_mfg_promo_price.cfm
141 ms 8 ms 18 C:/inetpub/wwwroot/includes/dropship.cfm
114 ms 6 ms 18 C:/inetpub/wwwroot/includes/qry_term_sale_price.cfm
32 ms 32 ms 1 E:/inetpub/wwwroot/queries/qry_getwebproducts_new.cfm
0 ms 0 ms 21 C:/inetpub/wwwroot/includes/brands.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/includes/metatags.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/includes/metatags_category_new.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/includes/navigation.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/includes/newfooter.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/includes/newheader.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/includes/security/block_access.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/includes/security/library.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/includes/security/sql_injection.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/Application.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/category_header_new.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/pagethru.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
2051 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time

SQL Queries

Getwebdepts (Datasource=celerantsql, Time=0ms, Records=0) in E:\inetpub\wwwroot\category.cfm @ 14:56:07.007
select * from tb_web_taxonomy with (nolock) where upper(web_url)=? and site = 'sportsman'
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = GIFTS-UNDER-100

get_term_sale_itemz (Datasource=celerantsql, Time=0ms, Records=1649, Cached Query) in E:\inetpub\wwwroot\queries\qry_getwebproducts_new.cfm @ 14:56:07.007
SELECT distinct b.style_id
    FROM tb_term_sale_entries b with (nolock) LEFT JOIN tb_term_sales a with (nolock) ON (a.term_sale_id=b.term_sale_id)
    WHERE b.start_date<= '2024-05-20 14:00:00' AND b.end_date >= '2024-05-20 14:00:00' AND b.store_id=10
get_pkg (Datasource=celerantsql, Time=0ms, Records=10) in E:\inetpub\wwwroot\queries\qry_getwebproducts_new.cfm @ 14:56:07.007
SELECT * 
	FROM tb_mfg_promo.dbo.tb_pkg a with (nolock)
	INNER JOIN tb_mfg_promo.dbo.tb_pkg_main_items b WITH (NOLOCK)
		ON (a.pkg_id = b.pkg_id) 
	WHERE 
	b.main_id is not NULL 
	and a.start_date<= '05/20/2024 23:59:00' and a.end_date >= '05/20/2024'
	
	and a.site='sportsman'
bulkitems (Datasource=celerantsql, Time=0ms, Records=18) in E:\inetpub\wwwroot\queries\qry_getwebproducts_new.cfm @ 14:56:07.007
select * from tb_mfg_promo.dbo.BULK_ITM_DSCS with (nolock)
GrandGetProducts (Datasource=celerantsql, Time=0ms, Records=2649, Cached Query) in E:\inetpub\wwwroot\queries\qry_getwebproducts_new.cfm @ 14:56:07.007
SELECT a.styles_web_taxonomy_id,max(a.style_id) as style_id,max(a.style) as style,max(a.web_style) as web_style,max(a.description) as web_desc,max(a.web_desc) as web_description,max(a.web_long_desc) as web_long_desc,max(a.picture_id) as picture_id,max(a.sort_position) as prod_sort_position,max(a.dept) as dept,max(a.typ) as typ,max(a.subtyp_1) as subtyp_1,max(a.subtyp_2) as subtyp_2,max(a.subtyp_3) as subtyp_3,max(a.category_style) as category_style,max(a.web_url) as web_url,max(a.sort_position) as sort_position,max(a.web_taxonomy_id) as web_taxonomy_id,max(a.brand) as brand,max(a.date_entered) as date_entered,max(a.non_invt) as non_invt,max(a.overnight_required) as overnight_required,max(a.is_firearm) as is_firearm,max(a.of1) as of1,max(a.of2) as of2,max(a.of3) as of3,max(a.of4) as of4,max(a.of5) as of5,max(a.of6) as of6,max(a.of7) as of7,max(a.of8) as of8,max(a.of9) as of9,max(a.of10) as of10,max(a.of11) as of11,max(a.of12) as of12,max(a.of13) as of13,max(a.of14) as of14,max(a.of15) as of15,max(a.of16) as of16,max(a.of17) as of17,max(a.of18) as of18,max(a.of19) as of19,max(a.of20) as of20
,min(c.price) as min_price,min(c.store_price) as store_price,max(c.sugg_price) as max_price,min(c.wholesale_price) as vipprice,max(c.qoh) as qoh,max(c.qc) as qc,max(c.qs) as qs,sum(qoh + qc) as available,sum(c.qs - c.qc) as sold,max(c.sugg_price) AS max_sugg_price,avg(CASE WHEN qq.of9 IS NULL OR qq.of9 = '' THEN 0 ELSE c.price / qq.of9 END) as round
	
 FROM web_all_products a WITH (NOLOCK)
 INNER JOIN dbo.tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
 INNER JOIN dbo.tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
 INNER JOIN dbo.tb_styles_web_taxonomy d WITH (NOLOCK) ON (a.style_id = d.style)
 INNER JOIN dbo.tb_styles qq WITH (NOLOCK) ON (qq.style_id = a.style_id)
	
	
 WHERE a.style_id > 0 and (a.of20='SPORTS' or a.of20='BOTH' or a.of20 = 'SPORTSOUTDOORS') and a.picture_id > 0
and qq.web_product='Y' and c.store_id=10 
	 and a.brand='SMITH AND WESSON'
	
	group by a.styles_web_taxonomy_id
GetProducts (Datasource=, Time=32ms, Records=1570) in E:\inetpub\wwwroot\queries\qry_getwebproducts_new.cfm @ 14:56:07.007
select
		distinct
		(style_id) as style_id
		, max(picture_id)
			,	min(min_price) as min_price
			,	max(max_price) as max_price
			,	min(vipprice) as vipprice
			,	max(web_style) as web_style
            ,	max(style) as style
			,	max(web_desc) as web_desc
            ,	max(web_description) as web_description
			,	max(picture_id) as picture_id
            ,	max(web_long_desc) as web_long_desc
			,   max(dept) as dept
			,   max(qoh) as qoh
			,	max(qc) as qc
			,	max(qs) as qs
			,	max(of18) as of18
			,	max(of17) as of17
			,	max(of15) as of15
            ,	max(of12) as of12
    		,	max(of10) as of10
    		,	max(of9) as of9
    		,	max(of8) as of8
			,	max(of7) as of7
    		,	max(of6) as of6
    		,	max(of5) as of5
            ,	max(of4) as of4
    		,	max(of3) as of3
            ,	max(of2) as of2
            ,	max(of1) as of1
			,	max(available) as available
            ,	max(available) as sold
			,   max(typ) as typ
            ,	max(round) as round
            ,	max(non_invt) as non_invt
			,	max(overnight_required) as overnight_required
			,   max(subtyp_1) as subtyp_1
			,   max(subtyp_2) as subtyp_2
			,   max(subtyp_3) as subtyp_3
			,   max(category_style) as category_style
		     ,   max(sort_position) as sort_position
		     ,max(brand) as brand
	,	MAX(max_sugg_price) AS max_sugg_price
    

		from grandgetproducts
		where
		 style_id is not null
            
				and brand='SMITH AND WESSON'
			


group by Style_id order by
min_price desc
GetProducts1 (Datasource=, Time=0ms, Records=2649) in E:\inetpub\wwwroot\queries\qry_getwebproducts_new.cfm @ 14:56:07.007
select * from grandgetproducts
		where
		 picture_id is not null
            
			
				and brand='SMITH AND WESSON'
			


order by

min_price
get_depts (Datasource=celerantsql, Time=0ms, Records=0, Cached Query) in E:\inetpub\wwwroot\category_sidenav_new.cfm @ 14:56:07.007
select dept, web_url ,sort_position, category_style from tb_web_taxonomy with (nolock) where typ='EMPTY' and dept<>'EMPTY' and dept='' and site = 'sportsman' order by sort_position
get_filtered_brands (Datasource=, Time=0ms, Records=1) in E:\inetpub\wwwroot\category_sidenav_new.cfm @ 14:56:07.007
select distinct(brand) as brand from GetProducts
brand_product_lines (Datasource=celerantsql, Time=157ms, Records=0) in E:\inetpub\wwwroot\category_sidenav_new.cfm @ 14:56:07.007
select distinct a.spec_value from tb_mfg_promo.dbo.item_spec_values a left join tb_mfg_promo.dbo.item_spec_names b on (a.spec_id=b.spec_id) left join tb_mfg_promo.dbo.item_specs c on (a.spec_value_id=c.spec_value_id) where b.spec_name = 'Product Line' and c.style_id in (189730,281768,203612,281769,134629,65231,48910,48914,48904,48916,81637,117757,48920,136427,133827,132542,48919,79472,189732,290173,290174,283158,290155,117429,48852,48854,48856,48858,203264,266679,266680,48752,48753,134627,157795,48912,107147,176008,205461,122572,106685,106998,48907,109732,48855,48898,220624,118279,118280,137838,97803,102178,122753,134630,112488,48896,266677,48918,123314,134628,75112,92111,48897,204789,285199,48767,178652,48845,122725,256908,134639,134626,95261,67716,149555,189731,207415,203613,64013,94699,119298,122752,269303,48794,114322,302079,134638,189711,48792,48786,73371,203593,203594,48923,48925,216705,73370,203599,266671,173191,193310,281263,48835,48837,48865,48866,49016,112396,114169,218295,218297,49057,278917,278911,108394,216706,256810,48766,260751,302760,302761,304769,48860,48862,272113,245691,48787,49050,103256,106999,173190,218298,266696,269823,277892,280196,281225,288887,125473,118282,116877,118581,178923,220030,220031,269843,269845,118281,118177,118189,145505,197052,115146,115382,117859,136017,150690,112486,269844,134634,207423,299119,48883,48884,48885,48892,134635,189721,189723,286627,286628,290170,290171,129037,105744,121254,123307,207414,215028,269842,189714,189716,189717,218308,48802,48804,109580,48886,48887,49015,192097,112487,48810,108064,137806,173193,204092,212067,217689,218305,242411,279957,280154,281189,281541,285345,290720,49014,48834,49055,298175,134636,266672,266673,266674,266675,266676,100197,212059,218303,218304,263845,48924,172794,266101,135600,142979,143193,143674,143801,185556,266669,269839,48864,111248,173189,207421,212051,212065,252391,288659,122751,269852,118187,112809,144010,147157,269838,212055,48772,99082,222706,269850,181361,48711,253027,307658,307659,48798,48800,48818,48820,209140,217662,118241,48713,136716,192093,218299,247280,247283,249746,283677,284842,289326,302759,260639,164551,247315,147161,173198,192094,207207,247286,48819,48875,118172,247276,274257,48831,48881,72176,106174,118277,290169,286650,247281,263847,48844,64010,109162,166590,173211,200023,213979,279942,287197,293016,302756,282715,266664,170303,247279,97510,111009,164552,266660,269837,264807,48841,170109,170286,181558,287198,302754,118173,157861,266665,281767,48888,151002,151003,173208,208686,218306,218307,247275,247277,167637,109731,118273,118203,250676,266658,125806,173183,173188,211795,213976,246992,247287,247289,247774,249809,281622,286229,287572,291089,292239,297991,303813,266657,142970,143767,248799,290017,138569,173180,173181,173184,205745,205746,207420,207422,211580,247278,254127,254128,261495,297563,104547,128766,148355,148697,210190,151004,151005,296422,147786,266663,148350,151783,247284,118188,197597,198698,200025,211798,213978,255630,289362,291744,287551,287552,288192,288193,264809,173192,218435,251298,251302,260583,266843,309514,302755,173212,178650,185645,188815,204098,212056,250016,251303,111301,86512,122917,168857,124931,203615,118271,170287,173256,48799,75401,103424,105625,110113,173152,183615,188831,198821,198822,202309,202495,207416,207418,207419,211797,212048,212060,213977,215419,217659,246985,246987,247260,248842,251299,252017,263843,267979,285439,288590,305632,133442,203614,273262,273263,276185,276186,289976,289986,293284,173186,188829,189734,198823,202801,202802,251300,252922,296903,132361,273250,273255,276183,276184,279521,279525,279641,290168,290172,189089,189090,274153,278938,269846,48824,48986,79833,188820,189461,212052,247648,296902,310316,269851,118240,278923,278924,250198,251012,212028,48921,91942,176031,218301,263839,296901,264912,266241,297594,250183,216709,263556,189031,189081,189083,266102,124932,126478,178870,200043,200044,202494,207417,210413,210414,217663,251301,252220,260635,269004,75612,88748,107981,161940,167897,172456,173153,173199,176018,188828,198820,202914,203616,208960,208966,210192,211111,222707,222708,254744,260753,261523,263840,274418,281844,287289,287901,287927,288304,291745,291913,291915,298922,310318,104561,48879,220026,305251,266104,266667,266668,276043,48991,48996,94100,128458,167958,207408,207411,207412,217661,264523,151774,118272,198978,214067,266105,269847,106297,176019,178734,178735,200036,210465,217660,266653,286467,114137,252221,266626,118488,48730,48731,173205,173206,175803,200033,200035,200039,201749,217322,225702,225703,249745,252753,268639,272173,48828,48829,48840,48880,48995,64137,64138,209482,290160,290166,290165,209481,266554,269849,189087,269853,161359,170677,183666,225683,225684,247274,48992,48997,124634,290161,279263,118238,198979,48976,48977,74554,143967,49007,67720,67721,104706,111344,113768,117394,121556,121926,132032,132615,159192,159587,161852,170100,170101,172836,175668,183979,193461,201750,202262,215183,215184,221016,221025,225354,225365,225685,242407,246964,246986,247269,247271,247354,247543,250432,257307,261496,276640,277896,281228,281324,281617,282148,282173,283353,285171,285204,285384,285775,285803,285841,285959,286194,287583,288925,289827,290715,290794,290817,291091,291742,291743,291919,292038,297395,298052,299214,305002,310317,290706,157751,276181,276182,285308,285309,189084,122758,122759,122915,168856,202483,266661,189080,189088,118206,115867,132720,132721,170108,172451,175907,179407,179408,200032,225701,273804,287950,290803,122916,129342,151764,118191,118192,118195,118237,135601,137807,205849,269848,48987,68102,72185,115914,170285,173255,189733,167737,48993,49005,49009,49011,78739,278921,151775,151778,290157,290158,245580,201495,114624,138185,143007,175669,225692,244952,244957,247350,247351,203608,203610,189085,175908,266662,278922,48870,92315,111528,118883,128235,167736,168616,172457,172667,173201,179405,181559,189726,196786,199529,200034,200040,201011,210620,225303,242390,247352,249744,256117,268614,279974,281213,287573,289433,296578,298940,299193,302569,302570,302572,302573,302574,309318,309606,271961,271962,271974,271975,278229,260640,123628,173200,189728,189729,172030,117447,142883,144678,148608,155210,161939,163837,170107,172453,172666,204094,218300,218302,291746,292822,296408,299194,211300,158175,115177,124889,134640,134645,147435,147642,147840,147895,168536,175906,194077,197599,197602,203833,203838,207522,207973,246983,260769,281537,285184,305082,305099,45320,49002,49004,278919,278920,172862,175446,175449,150757,85487,134647,134648,151765,157750,158069,175734,201751,202803,209475,220421,228365,150758,205448,205835,100193,290181,116735,175729,48729,48732,67711,96872,107774,115738,122971,133164,139962,151767,151769,151770,151955,158514,161941,163874,164782,168540,172452,172455,172650,172796,173202,193074,197327,197604,197605,204109,207409,214089,218589,225292,225358,228585,246984,249742,249817,249818,251210,267809,267813,267815,267822,277888,277893,279988,280828,282158,282164,282182,283215,283629,285086,285090,285092,285425,285922,286281,291747,291923,292823,292826,292976,296409,298053,298743,299067,302575,305073,305104,309609,264364,264365,264909,264911,285482,285483,290177,290178,145195,172033,201496,201498,269831,215600,116860,147434,168973,182500,182504,182505,182506,207519,297888,115288,165384,168439,144682,130716,133569,133570,134637,134643,138481,145486,152013,165385,172714,175546,176030,181418,192956,200041,200042,203606,203607,205191,205192,205193,205623,205624,217844,260981,279991,280164,280868,285087,285091,287982,292848,292851,305052,305647,309317,130717,201492,201493,110381,134641,134644,134646,48735,48736,120379,165157,172665,189306,193462,200038,220419,249743,288044,292824,292827,296360,296410,84585,58807,79177,172913,179406,207525,208722,208723,210466,211138,218327,297251,118196,141538,142978,292574,292575,138157,157986,48734,48962,48963,48965,73343,73344,73345,73346,112084,113783,117878,119408,122332,123645,128793,133625,134176,137051,170781,172841,173493,175547,178666,181133,192759,202178,202179,205188,211041,213470,220720,220932,220991,227793,228461,228505,247804,267855,267877,268463,268622,268637,280862,281426,281727,282289,282619,283364,285089,285818,285856,286210,288055,290514,290653,290820,292849,292852,294760,294873,296616,297387,297394,298326,298941,299022,300769,300773,300775,300776,301150,305064,305078,305566,309591,132724,85488,134642,172696,205189,208724,292828,178869,143260,167833,169103,179412,192096,283352,285409,286586,290567,290599,290638,290698,292987,298946,300588,305627,107404,116856,132723,172649,172713,175075,192095,205102,205190,218564,218565,228459,245598,283366,285428,285430,285813,292850,292853,292986,294951,296626,297252,297407,299045,300762,305081,307692,307695,307798,307810,307892,309592,115143,143480,143481,137676,115142,48701,216883,203611,122792,128226,133828,172651,172721,179239,183662,197639,208202,222775,228460,228608,242093,242393,247761,267793,267806,267842,272108,278368,279989,280158,280836,280846,280855,280856,281158,281159,281374,281400,281732,281735,281746,285873,286307,287930,288061,288077,289770,290663,290711,290724,290753,290758,291971,292855,292856,293003,293105,294938,298965,298971,299046,299223,300590,301148,301307,304994,305028,305060,305088,305596,300750,108995,129398,132722,181563,73024,163276,242415,267787,282170,287903,290665,291046,293001,299002,299019,48699,76932,169230,179411,189361,163875,203603,121649,211586,222682,225305,242381,247533,267785,267786,267791,267795,267797,267869,277891,277895,280017,280019,280844,280853,280860,281365,281368,281377,281425,285347,285379,285410,285416,285427,285774,285780,285786,286308,287900,290502,290506,290730,290734,290739,290746,292996,292998,296454,296473,296630,297392,299307,307693,307754,288135,247534,280854,285188,285413,285930,150848,283356,287924,288890,290590,290749,290787,290825,298726,299006,299060,299308,307689,307698,307702,307894,118777,193439,215235,220974,220975,220982,220989,221035,225267,225283,228591,228599,228603,228613,247610,247813,281633,285201,285380,285381,285843,285880,285949,287922,287936,288052,288059,288078,289754,294940,297366,297374,297584,298054,298943,298944,299004,299005,299210,299220,299238,299325,300610,301341,301552,305061,305083,305556,305624,307897,309296,309299,309344,309351,309490,309493,309603,310319,111392,188229,220976,220984,220986,220988,220994,228593,285346,285492,288031,299322,301549,305606,307707,152910,66225,216708,296907,264674,264675,49025,161406,289232,122327,129286,48946,148141,69611,84399,147932,196395,219660,264913,285249,287291,296904,296905,306801,66435,49020,120896,170252,203618,216707,247322,281763,121874,277012,48943,48944,48945,65289,65290,65291,75189,120350,123330,126271,138138,179413,181572,201756,203617,206654,250088,296354,92765,92767,48930,99863,122866,158521,204314,209125,209486,274419,289556,169265,293450,157760,203515,48981,48941,48932,48935,79377,133339,135771,141296,49024,220309,161405,102277,49023,200024,207110,113780,147930,147931,196859,203384,206272,208945,208946,211572,270006,270007,48933,97139,147934,147933,148914)
get_depts_by_brand (Datasource=, Time=15ms, Records=6) in E:\inetpub\wwwroot\category_sidenav_new.cfm @ 14:56:07.007
select distinct (dept) as dept from getproducts1 where brand='SMITH AND WESSON' group by dept
get_details (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\category_sidenav_new.cfm @ 14:56:07.007
select web_url, picture_id, web_taxonomy_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='California Guns' and typ='EMPTY' and site = 'sportsman'
brand_product_lines (Datasource=celerantsql, Time=158ms, Records=0) in E:\inetpub\wwwroot\category_sidenav_new.cfm @ 14:56:07.007
select distinct a.spec_value 
                                from 
                                    tb_mfg_promo.dbo.item_spec_values a 
                                left join 
                                    tb_web_taxonomy b on (a.spec_dept=b.web_taxonomy_id) 
                                left join 
                                    tb_mfg_promo.dbo.item_specs c on (a.spec_value_id=c.spec_value_id)
                                where 
                                    a.spec_dept = 792 and c.style_id in (189730,281768,203612,281769,134629,65231,48910,48914,48904,48916,81637,117757,48920,136427,133827,132542,48919,79472,189732,290173,290174,283158,290155,117429,48852,48854,48856,48858,203264,266679,266680,48752,48753,134627,157795,48912,107147,176008,205461,122572,106685,106998,48907,109732,48855,48898,220624,118279,118280,137838,97803,102178,122753,134630,112488,48896,266677,48918,123314,134628,75112,92111,48897,204789,285199,48767,178652,48845,122725,256908,134639,134626,95261,67716,149555,189731,207415,203613,64013,94699,119298,122752,269303,48794,114322,302079,134638,189711,48792,48786,73371,203593,203594,48923,48925,216705,73370,203599,266671,173191,193310,281263,48835,48837,48865,48866,49016,112396,114169,218295,218297,49057,278917,278911,108394,216706,256810,48766,260751,302760,302761,304769,48860,48862,272113,245691,48787,49050,103256,106999,173190,218298,266696,269823,277892,280196,281225,288887,125473,118282,116877,118581,178923,220030,220031,269843,269845,118281,118177,118189,145505,197052,115146,115382,117859,136017,150690,112486,269844,134634,207423,299119,48883,48884,48885,48892,134635,189721,189723,286627,286628,290170,290171,129037,105744,121254,123307,207414,215028,269842,189714,189716,189717,218308,48802,48804,109580,48886,48887,49015,192097,112487,48810,108064,137806,173193,204092,212067,217689,218305,242411,279957,280154,281189,281541,285345,290720,49014,48834,49055,298175,134636,266672,266673,266674,266675,266676,100197,212059,218303,218304,263845,48924,172794,266101,135600,142979,143193,143674,143801,185556,266669,269839,48864,111248,173189,207421,212051,212065,252391,288659,122751,269852,118187,112809,144010,147157,269838,212055,48772,99082,222706,269850,181361,48711,253027,307658,307659,48798,48800,48818,48820,209140,217662,118241,48713,136716,192093,218299,247280,247283,249746,283677,284842,289326,302759,260639,164551,247315,147161,173198,192094,207207,247286,48819,48875,118172,247276,274257,48831,48881,72176,106174,118277,290169,286650,247281,263847,48844,64010,109162,166590,173211,200023,213979,279942,287197,293016,302756,282715,266664,170303,247279,97510,111009,164552,266660,269837,264807,48841,170109,170286,181558,287198,302754,118173,157861,266665,281767,48888,151002,151003,173208,208686,218306,218307,247275,247277,167637,109731,118273,118203,250676,266658,125806,173183,173188,211795,213976,246992,247287,247289,247774,249809,281622,286229,287572,291089,292239,297991,303813,266657,142970,143767,248799,290017,138569,173180,173181,173184,205745,205746,207420,207422,211580,247278,254127,254128,261495,297563,104547,128766,148355,148697,210190,151004,151005,296422,147786,266663,148350,151783,247284,118188,197597,198698,200025,211798,213978,255630,289362,291744,287551,287552,288192,288193,264809,173192,218435,251298,251302,260583,266843,309514,302755,173212,178650,185645,188815,204098,212056,250016,251303,111301,86512,122917,168857,124931,203615,118271,170287,173256,48799,75401,103424,105625,110113,173152,183615,188831,198821,198822,202309,202495,207416,207418,207419,211797,212048,212060,213977,215419,217659,246985,246987,247260,248842,251299,252017,263843,267979,285439,288590,305632,133442,203614,273262,273263,276185,276186,289976,289986,293284,173186,188829,189734,198823,202801,202802,251300,252922,296903,132361,273250,273255,276183,276184,279521,279525,279641,290168,290172,189089,189090,274153,278938,269846,48824,48986,79833,188820,189461,212052,247648,296902,310316,269851,118240,278923,278924,250198,251012,212028,48921,91942,176031,218301,263839,296901,264912,266241,297594,250183,216709,263556,189031,189081,189083,266102,124932,126478,178870,200043,200044,202494,207417,210413,210414,217663,251301,252220,260635,269004,75612,88748,107981,161940,167897,172456,173153,173199,176018,188828,198820,202914,203616,208960,208966,210192,211111,222707,222708,254744,260753,261523,263840,274418,281844,287289,287901,287927,288304,291745,291913,291915,298922,310318,104561,48879,220026,305251,266104,266667,266668,276043,48991,48996,94100,128458,167958,207408,207411,207412,217661,264523,151774,118272,198978,214067,266105,269847,106297,176019,178734,178735,200036,210465,217660,266653,286467,114137,252221,266626,118488,48730,48731,173205,173206,175803,200033,200035,200039,201749,217322,225702,225703,249745,252753,268639,272173,48828,48829,48840,48880,48995,64137,64138,209482,290160,290166,290165,209481,266554,269849,189087,269853,161359,170677,183666,225683,225684,247274,48992,48997,124634,290161,279263,118238,198979,48976,48977,74554,143967,49007,67720,67721,104706,111344,113768,117394,121556,121926,132032,132615,159192,159587,161852,170100,170101,172836,175668,183979,193461,201750,202262,215183,215184,221016,221025,225354,225365,225685,242407,246964,246986,247269,247271,247354,247543,250432,257307,261496,276640,277896,281228,281324,281617,282148,282173,283353,285171,285204,285384,285775,285803,285841,285959,286194,287583,288925,289827,290715,290794,290817,291091,291742,291743,291919,292038,297395,298052,299214,305002,310317,290706,157751,276181,276182,285308,285309,189084,122758,122759,122915,168856,202483,266661,189080,189088,118206,115867,132720,132721,170108,172451,175907,179407,179408,200032,225701,273804,287950,290803,122916,129342,151764,118191,118192,118195,118237,135601,137807,205849,269848,48987,68102,72185,115914,170285,173255,189733,167737,48993,49005,49009,49011,78739,278921,151775,151778,290157,290158,245580,201495,114624,138185,143007,175669,225692,244952,244957,247350,247351,203608,203610,189085,175908,266662,278922,48870,92315,111528,118883,128235,167736,168616,172457,172667,173201,179405,181559,189726,196786,199529,200034,200040,201011,210620,225303,242390,247352,249744,256117,268614,279974,281213,287573,289433,296578,298940,299193,302569,302570,302572,302573,302574,309318,309606,271961,271962,271974,271975,278229,260640,123628,173200,189728,189729,172030,117447,142883,144678,148608,155210,161939,163837,170107,172453,172666,204094,218300,218302,291746,292822,296408,299194,211300,158175,115177,124889,134640,134645,147435,147642,147840,147895,168536,175906,194077,197599,197602,203833,203838,207522,207973,246983,260769,281537,285184,305082,305099,45320,49002,49004,278919,278920,172862,175446,175449,150757,85487,134647,134648,151765,157750,158069,175734,201751,202803,209475,220421,228365,150758,205448,205835,100193,290181,116735,175729,48729,48732,67711,96872,107774,115738,122971,133164,139962,151767,151769,151770,151955,158514,161941,163874,164782,168540,172452,172455,172650,172796,173202,193074,197327,197604,197605,204109,207409,214089,218589,225292,225358,228585,246984,249742,249817,249818,251210,267809,267813,267815,267822,277888,277893,279988,280828,282158,282164,282182,283215,283629,285086,285090,285092,285425,285922,286281,291747,291923,292823,292826,292976,296409,298053,298743,299067,302575,305073,305104,309609,264364,264365,264909,264911,285482,285483,290177,290178,145195,172033,201496,201498,269831,215600,116860,147434,168973,182500,182504,182505,182506,207519,297888,115288,165384,168439,144682,130716,133569,133570,134637,134643,138481,145486,152013,165385,172714,175546,176030,181418,192956,200041,200042,203606,203607,205191,205192,205193,205623,205624,217844,260981,279991,280164,280868,285087,285091,287982,292848,292851,305052,305647,309317,130717,201492,201493,110381,134641,134644,134646,48735,48736,120379,165157,172665,189306,193462,200038,220419,249743,288044,292824,292827,296360,296410,84585,58807,79177,172913,179406,207525,208722,208723,210466,211138,218327,297251,118196,141538,142978,292574,292575,138157,157986,48734,48962,48963,48965,73343,73344,73345,73346,112084,113783,117878,119408,122332,123645,128793,133625,134176,137051,170781,172841,173493,175547,178666,181133,192759,202178,202179,205188,211041,213470,220720,220932,220991,227793,228461,228505,247804,267855,267877,268463,268622,268637,280862,281426,281727,282289,282619,283364,285089,285818,285856,286210,288055,290514,290653,290820,292849,292852,294760,294873,296616,297387,297394,298326,298941,299022,300769,300773,300775,300776,301150,305064,305078,305566,309591,132724,85488,134642,172696,205189,208724,292828,178869,143260,167833,169103,179412,192096,283352,285409,286586,290567,290599,290638,290698,292987,298946,300588,305627,107404,116856,132723,172649,172713,175075,192095,205102,205190,218564,218565,228459,245598,283366,285428,285430,285813,292850,292853,292986,294951,296626,297252,297407,299045,300762,305081,307692,307695,307798,307810,307892,309592,115143,143480,143481,137676,115142,48701,216883,203611,122792,128226,133828,172651,172721,179239,183662,197639,208202,222775,228460,228608,242093,242393,247761,267793,267806,267842,272108,278368,279989,280158,280836,280846,280855,280856,281158,281159,281374,281400,281732,281735,281746,285873,286307,287930,288061,288077,289770,290663,290711,290724,290753,290758,291971,292855,292856,293003,293105,294938,298965,298971,299046,299223,300590,301148,301307,304994,305028,305060,305088,305596,300750,108995,129398,132722,181563,73024,163276,242415,267787,282170,287903,290665,291046,293001,299002,299019,48699,76932,169230,179411,189361,163875,203603,121649,211586,222682,225305,242381,247533,267785,267786,267791,267795,267797,267869,277891,277895,280017,280019,280844,280853,280860,281365,281368,281377,281425,285347,285379,285410,285416,285427,285774,285780,285786,286308,287900,290502,290506,290730,290734,290739,290746,292996,292998,296454,296473,296630,297392,299307,307693,307754,288135,247534,280854,285188,285413,285930,150848,283356,287924,288890,290590,290749,290787,290825,298726,299006,299060,299308,307689,307698,307702,307894,118777,193439,215235,220974,220975,220982,220989,221035,225267,225283,228591,228599,228603,228613,247610,247813,281633,285201,285380,285381,285843,285880,285949,287922,287936,288052,288059,288078,289754,294940,297366,297374,297584,298054,298943,298944,299004,299005,299210,299220,299238,299325,300610,301341,301552,305061,305083,305556,305624,307897,309296,309299,309344,309351,309490,309493,309603,310319,111392,188229,220976,220984,220986,220988,220994,228593,285346,285492,288031,299322,301549,305606,307707,152910,66225,216708,296907,264674,264675,49025,161406,289232,122327,129286,48946,148141,69611,84399,147932,196395,219660,264913,285249,287291,296904,296905,306801,66435,49020,120896,170252,203618,216707,247322,281763,121874,277012,48943,48944,48945,65289,65290,65291,75189,120350,123330,126271,138138,179413,181572,201756,203617,206654,250088,296354,92765,92767,48930,99863,122866,158521,204314,209125,209486,274419,289556,169265,293450,157760,203515,48981,48941,48932,48935,79377,133339,135771,141296,49024,220309,161405,102277,49023,200024,207110,113780,147930,147931,196859,203384,206272,208945,208946,211572,270006,270007,48933,97139,147934,147933,148914)
get_typs (Datasource=, Time=0ms, Records=2) in E:\inetpub\wwwroot\category_sidenav_new.cfm @ 14:56:07.007
select distinct typ from getproducts1 where dept='California Guns' and brand='SMITH AND WESSON' group by typ order by sort_position
get_details (Datasource=celerantsql, Time=16ms, Records=1) in E:\inetpub\wwwroot\category_sidenav_new.cfm @ 14:56:07.007
select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='California Guns' and typ='California Handguns' and subtyp_1='EMPTY' and site = 'sportsman'
get_details (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\category_sidenav_new.cfm @ 14:56:07.007
select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='California Guns' and typ='California Rifles' and subtyp_1='EMPTY' and site = 'sportsman'
get_details (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\category_sidenav_new.cfm @ 14:56:07.007
select web_url, picture_id, web_taxonomy_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Firearm Accessories' and typ='EMPTY' and site = 'sportsman'
brand_product_lines (Datasource=celerantsql, Time=157ms, Records=0) in E:\inetpub\wwwroot\category_sidenav_new.cfm @ 14:56:08.008
select distinct a.spec_value 
                                from 
                                    tb_mfg_promo.dbo.item_spec_values a 
                                left join 
                                    tb_web_taxonomy b on (a.spec_dept=b.web_taxonomy_id) 
                                left join 
                                    tb_mfg_promo.dbo.item_specs c on (a.spec_value_id=c.spec_value_id)
                                where 
                                    a.spec_dept = 17 and c.style_id in (189730,281768,203612,281769,134629,65231,48910,48914,48904,48916,81637,117757,48920,136427,133827,132542,48919,79472,189732,290173,290174,283158,290155,117429,48852,48854,48856,48858,203264,266679,266680,48752,48753,134627,157795,48912,107147,176008,205461,122572,106685,106998,48907,109732,48855,48898,220624,118279,118280,137838,97803,102178,122753,134630,112488,48896,266677,48918,123314,134628,75112,92111,48897,204789,285199,48767,178652,48845,122725,256908,134639,134626,95261,67716,149555,189731,207415,203613,64013,94699,119298,122752,269303,48794,114322,302079,134638,189711,48792,48786,73371,203593,203594,48923,48925,216705,73370,203599,266671,173191,193310,281263,48835,48837,48865,48866,49016,112396,114169,218295,218297,49057,278917,278911,108394,216706,256810,48766,260751,302760,302761,304769,48860,48862,272113,245691,48787,49050,103256,106999,173190,218298,266696,269823,277892,280196,281225,288887,125473,118282,116877,118581,178923,220030,220031,269843,269845,118281,118177,118189,145505,197052,115146,115382,117859,136017,150690,112486,269844,134634,207423,299119,48883,48884,48885,48892,134635,189721,189723,286627,286628,290170,290171,129037,105744,121254,123307,207414,215028,269842,189714,189716,189717,218308,48802,48804,109580,48886,48887,49015,192097,112487,48810,108064,137806,173193,204092,212067,217689,218305,242411,279957,280154,281189,281541,285345,290720,49014,48834,49055,298175,134636,266672,266673,266674,266675,266676,100197,212059,218303,218304,263845,48924,172794,266101,135600,142979,143193,143674,143801,185556,266669,269839,48864,111248,173189,207421,212051,212065,252391,288659,122751,269852,118187,112809,144010,147157,269838,212055,48772,99082,222706,269850,181361,48711,253027,307658,307659,48798,48800,48818,48820,209140,217662,118241,48713,136716,192093,218299,247280,247283,249746,283677,284842,289326,302759,260639,164551,247315,147161,173198,192094,207207,247286,48819,48875,118172,247276,274257,48831,48881,72176,106174,118277,290169,286650,247281,263847,48844,64010,109162,166590,173211,200023,213979,279942,287197,293016,302756,282715,266664,170303,247279,97510,111009,164552,266660,269837,264807,48841,170109,170286,181558,287198,302754,118173,157861,266665,281767,48888,151002,151003,173208,208686,218306,218307,247275,247277,167637,109731,118273,118203,250676,266658,125806,173183,173188,211795,213976,246992,247287,247289,247774,249809,281622,286229,287572,291089,292239,297991,303813,266657,142970,143767,248799,290017,138569,173180,173181,173184,205745,205746,207420,207422,211580,247278,254127,254128,261495,297563,104547,128766,148355,148697,210190,151004,151005,296422,147786,266663,148350,151783,247284,118188,197597,198698,200025,211798,213978,255630,289362,291744,287551,287552,288192,288193,264809,173192,218435,251298,251302,260583,266843,309514,302755,173212,178650,185645,188815,204098,212056,250016,251303,111301,86512,122917,168857,124931,203615,118271,170287,173256,48799,75401,103424,105625,110113,173152,183615,188831,198821,198822,202309,202495,207416,207418,207419,211797,212048,212060,213977,215419,217659,246985,246987,247260,248842,251299,252017,263843,267979,285439,288590,305632,133442,203614,273262,273263,276185,276186,289976,289986,293284,173186,188829,189734,198823,202801,202802,251300,252922,296903,132361,273250,273255,276183,276184,279521,279525,279641,290168,290172,189089,189090,274153,278938,269846,48824,48986,79833,188820,189461,212052,247648,296902,310316,269851,118240,278923,278924,250198,251012,212028,48921,91942,176031,218301,263839,296901,264912,266241,297594,250183,216709,263556,189031,189081,189083,266102,124932,126478,178870,200043,200044,202494,207417,210413,210414,217663,251301,252220,260635,269004,75612,88748,107981,161940,167897,172456,173153,173199,176018,188828,198820,202914,203616,208960,208966,210192,211111,222707,222708,254744,260753,261523,263840,274418,281844,287289,287901,287927,288304,291745,291913,291915,298922,310318,104561,48879,220026,305251,266104,266667,266668,276043,48991,48996,94100,128458,167958,207408,207411,207412,217661,264523,151774,118272,198978,214067,266105,269847,106297,176019,178734,178735,200036,210465,217660,266653,286467,114137,252221,266626,118488,48730,48731,173205,173206,175803,200033,200035,200039,201749,217322,225702,225703,249745,252753,268639,272173,48828,48829,48840,48880,48995,64137,64138,209482,290160,290166,290165,209481,266554,269849,189087,269853,161359,170677,183666,225683,225684,247274,48992,48997,124634,290161,279263,118238,198979,48976,48977,74554,143967,49007,67720,67721,104706,111344,113768,117394,121556,121926,132032,132615,159192,159587,161852,170100,170101,172836,175668,183979,193461,201750,202262,215183,215184,221016,221025,225354,225365,225685,242407,246964,246986,247269,247271,247354,247543,250432,257307,261496,276640,277896,281228,281324,281617,282148,282173,283353,285171,285204,285384,285775,285803,285841,285959,286194,287583,288925,289827,290715,290794,290817,291091,291742,291743,291919,292038,297395,298052,299214,305002,310317,290706,157751,276181,276182,285308,285309,189084,122758,122759,122915,168856,202483,266661,189080,189088,118206,115867,132720,132721,170108,172451,175907,179407,179408,200032,225701,273804,287950,290803,122916,129342,151764,118191,118192,118195,118237,135601,137807,205849,269848,48987,68102,72185,115914,170285,173255,189733,167737,48993,49005,49009,49011,78739,278921,151775,151778,290157,290158,245580,201495,114624,138185,143007,175669,225692,244952,244957,247350,247351,203608,203610,189085,175908,266662,278922,48870,92315,111528,118883,128235,167736,168616,172457,172667,173201,179405,181559,189726,196786,199529,200034,200040,201011,210620,225303,242390,247352,249744,256117,268614,279974,281213,287573,289433,296578,298940,299193,302569,302570,302572,302573,302574,309318,309606,271961,271962,271974,271975,278229,260640,123628,173200,189728,189729,172030,117447,142883,144678,148608,155210,161939,163837,170107,172453,172666,204094,218300,218302,291746,292822,296408,299194,211300,158175,115177,124889,134640,134645,147435,147642,147840,147895,168536,175906,194077,197599,197602,203833,203838,207522,207973,246983,260769,281537,285184,305082,305099,45320,49002,49004,278919,278920,172862,175446,175449,150757,85487,134647,134648,151765,157750,158069,175734,201751,202803,209475,220421,228365,150758,205448,205835,100193,290181,116735,175729,48729,48732,67711,96872,107774,115738,122971,133164,139962,151767,151769,151770,151955,158514,161941,163874,164782,168540,172452,172455,172650,172796,173202,193074,197327,197604,197605,204109,207409,214089,218589,225292,225358,228585,246984,249742,249817,249818,251210,267809,267813,267815,267822,277888,277893,279988,280828,282158,282164,282182,283215,283629,285086,285090,285092,285425,285922,286281,291747,291923,292823,292826,292976,296409,298053,298743,299067,302575,305073,305104,309609,264364,264365,264909,264911,285482,285483,290177,290178,145195,172033,201496,201498,269831,215600,116860,147434,168973,182500,182504,182505,182506,207519,297888,115288,165384,168439,144682,130716,133569,133570,134637,134643,138481,145486,152013,165385,172714,175546,176030,181418,192956,200041,200042,203606,203607,205191,205192,205193,205623,205624,217844,260981,279991,280164,280868,285087,285091,287982,292848,292851,305052,305647,309317,130717,201492,201493,110381,134641,134644,134646,48735,48736,120379,165157,172665,189306,193462,200038,220419,249743,288044,292824,292827,296360,296410,84585,58807,79177,172913,179406,207525,208722,208723,210466,211138,218327,297251,118196,141538,142978,292574,292575,138157,157986,48734,48962,48963,48965,73343,73344,73345,73346,112084,113783,117878,119408,122332,123645,128793,133625,134176,137051,170781,172841,173493,175547,178666,181133,192759,202178,202179,205188,211041,213470,220720,220932,220991,227793,228461,228505,247804,267855,267877,268463,268622,268637,280862,281426,281727,282289,282619,283364,285089,285818,285856,286210,288055,290514,290653,290820,292849,292852,294760,294873,296616,297387,297394,298326,298941,299022,300769,300773,300775,300776,301150,305064,305078,305566,309591,132724,85488,134642,172696,205189,208724,292828,178869,143260,167833,169103,179412,192096,283352,285409,286586,290567,290599,290638,290698,292987,298946,300588,305627,107404,116856,132723,172649,172713,175075,192095,205102,205190,218564,218565,228459,245598,283366,285428,285430,285813,292850,292853,292986,294951,296626,297252,297407,299045,300762,305081,307692,307695,307798,307810,307892,309592,115143,143480,143481,137676,115142,48701,216883,203611,122792,128226,133828,172651,172721,179239,183662,197639,208202,222775,228460,228608,242093,242393,247761,267793,267806,267842,272108,278368,279989,280158,280836,280846,280855,280856,281158,281159,281374,281400,281732,281735,281746,285873,286307,287930,288061,288077,289770,290663,290711,290724,290753,290758,291971,292855,292856,293003,293105,294938,298965,298971,299046,299223,300590,301148,301307,304994,305028,305060,305088,305596,300750,108995,129398,132722,181563,73024,163276,242415,267787,282170,287903,290665,291046,293001,299002,299019,48699,76932,169230,179411,189361,163875,203603,121649,211586,222682,225305,242381,247533,267785,267786,267791,267795,267797,267869,277891,277895,280017,280019,280844,280853,280860,281365,281368,281377,281425,285347,285379,285410,285416,285427,285774,285780,285786,286308,287900,290502,290506,290730,290734,290739,290746,292996,292998,296454,296473,296630,297392,299307,307693,307754,288135,247534,280854,285188,285413,285930,150848,283356,287924,288890,290590,290749,290787,290825,298726,299006,299060,299308,307689,307698,307702,307894,118777,193439,215235,220974,220975,220982,220989,221035,225267,225283,228591,228599,228603,228613,247610,247813,281633,285201,285380,285381,285843,285880,285949,287922,287936,288052,288059,288078,289754,294940,297366,297374,297584,298054,298943,298944,299004,299005,299210,299220,299238,299325,300610,301341,301552,305061,305083,305556,305624,307897,309296,309299,309344,309351,309490,309493,309603,310319,111392,188229,220976,220984,220986,220988,220994,228593,285346,285492,288031,299322,301549,305606,307707,152910,66225,216708,296907,264674,264675,49025,161406,289232,122327,129286,48946,148141,69611,84399,147932,196395,219660,264913,285249,287291,296904,296905,306801,66435,49020,120896,170252,203618,216707,247322,281763,121874,277012,48943,48944,48945,65289,65290,65291,75189,120350,123330,126271,138138,179413,181572,201756,203617,206654,250088,296354,92765,92767,48930,99863,122866,158521,204314,209125,209486,274419,289556,169265,293450,157760,203515,48981,48941,48932,48935,79377,133339,135771,141296,49024,220309,161405,102277,49023,200024,207110,113780,147930,147931,196859,203384,206272,208945,208946,211572,270006,270007,48933,97139,147934,147933,148914)
get_typs (Datasource=, Time=0ms, Records=5) in E:\inetpub\wwwroot\category_sidenav_new.cfm @ 14:56:08.008
select distinct typ from getproducts1 where dept='Firearm Accessories' and brand='SMITH AND WESSON' group by typ order by sort_position
get_details (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\category_sidenav_new.cfm @ 14:56:08.008
select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Firearm Accessories' and typ='Gun Parts' and subtyp_1='EMPTY' and site = 'sportsman'
get_details (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\category_sidenav_new.cfm @ 14:56:08.008
select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Firearm Accessories' and typ='Gun Storage' and subtyp_1='EMPTY' and site = 'sportsman'
get_details (Datasource=celerantsql, Time=15ms, Records=1) in E:\inetpub\wwwroot\category_sidenav_new.cfm @ 14:56:08.008
select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Firearm Accessories' and typ='Magazines' and subtyp_1='EMPTY' and site = 'sportsman'
get_details (Datasource=celerantsql, Time=2ms, Records=1) in E:\inetpub\wwwroot\category_sidenav_new.cfm @ 14:56:08.008
select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Firearm Accessories' and typ='Optics' and subtyp_1='EMPTY' and site = 'sportsman'
get_details (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\category_sidenav_new.cfm @ 14:56:08.008
select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Firearm Accessories' and typ='Speedloaders' and subtyp_1='EMPTY' and site = 'sportsman'
get_details (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\category_sidenav_new.cfm @ 14:56:08.008
select web_url, picture_id, web_taxonomy_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Firearms' and typ='EMPTY' and site = 'sportsman'
brand_product_lines (Datasource=celerantsql, Time=174ms, Records=0) in E:\inetpub\wwwroot\category_sidenav_new.cfm @ 14:56:08.008
select distinct a.spec_value 
                                from 
                                    tb_mfg_promo.dbo.item_spec_values a 
                                left join 
                                    tb_web_taxonomy b on (a.spec_dept=b.web_taxonomy_id) 
                                left join 
                                    tb_mfg_promo.dbo.item_specs c on (a.spec_value_id=c.spec_value_id)
                                where 
                                    a.spec_dept = 18 and c.style_id in (189730,281768,203612,281769,134629,65231,48910,48914,48904,48916,81637,117757,48920,136427,133827,132542,48919,79472,189732,290173,290174,283158,290155,117429,48852,48854,48856,48858,203264,266679,266680,48752,48753,134627,157795,48912,107147,176008,205461,122572,106685,106998,48907,109732,48855,48898,220624,118279,118280,137838,97803,102178,122753,134630,112488,48896,266677,48918,123314,134628,75112,92111,48897,204789,285199,48767,178652,48845,122725,256908,134639,134626,95261,67716,149555,189731,207415,203613,64013,94699,119298,122752,269303,48794,114322,302079,134638,189711,48792,48786,73371,203593,203594,48923,48925,216705,73370,203599,266671,173191,193310,281263,48835,48837,48865,48866,49016,112396,114169,218295,218297,49057,278917,278911,108394,216706,256810,48766,260751,302760,302761,304769,48860,48862,272113,245691,48787,49050,103256,106999,173190,218298,266696,269823,277892,280196,281225,288887,125473,118282,116877,118581,178923,220030,220031,269843,269845,118281,118177,118189,145505,197052,115146,115382,117859,136017,150690,112486,269844,134634,207423,299119,48883,48884,48885,48892,134635,189721,189723,286627,286628,290170,290171,129037,105744,121254,123307,207414,215028,269842,189714,189716,189717,218308,48802,48804,109580,48886,48887,49015,192097,112487,48810,108064,137806,173193,204092,212067,217689,218305,242411,279957,280154,281189,281541,285345,290720,49014,48834,49055,298175,134636,266672,266673,266674,266675,266676,100197,212059,218303,218304,263845,48924,172794,266101,135600,142979,143193,143674,143801,185556,266669,269839,48864,111248,173189,207421,212051,212065,252391,288659,122751,269852,118187,112809,144010,147157,269838,212055,48772,99082,222706,269850,181361,48711,253027,307658,307659,48798,48800,48818,48820,209140,217662,118241,48713,136716,192093,218299,247280,247283,249746,283677,284842,289326,302759,260639,164551,247315,147161,173198,192094,207207,247286,48819,48875,118172,247276,274257,48831,48881,72176,106174,118277,290169,286650,247281,263847,48844,64010,109162,166590,173211,200023,213979,279942,287197,293016,302756,282715,266664,170303,247279,97510,111009,164552,266660,269837,264807,48841,170109,170286,181558,287198,302754,118173,157861,266665,281767,48888,151002,151003,173208,208686,218306,218307,247275,247277,167637,109731,118273,118203,250676,266658,125806,173183,173188,211795,213976,246992,247287,247289,247774,249809,281622,286229,287572,291089,292239,297991,303813,266657,142970,143767,248799,290017,138569,173180,173181,173184,205745,205746,207420,207422,211580,247278,254127,254128,261495,297563,104547,128766,148355,148697,210190,151004,151005,296422,147786,266663,148350,151783,247284,118188,197597,198698,200025,211798,213978,255630,289362,291744,287551,287552,288192,288193,264809,173192,218435,251298,251302,260583,266843,309514,302755,173212,178650,185645,188815,204098,212056,250016,251303,111301,86512,122917,168857,124931,203615,118271,170287,173256,48799,75401,103424,105625,110113,173152,183615,188831,198821,198822,202309,202495,207416,207418,207419,211797,212048,212060,213977,215419,217659,246985,246987,247260,248842,251299,252017,263843,267979,285439,288590,305632,133442,203614,273262,273263,276185,276186,289976,289986,293284,173186,188829,189734,198823,202801,202802,251300,252922,296903,132361,273250,273255,276183,276184,279521,279525,279641,290168,290172,189089,189090,274153,278938,269846,48824,48986,79833,188820,189461,212052,247648,296902,310316,269851,118240,278923,278924,250198,251012,212028,48921,91942,176031,218301,263839,296901,264912,266241,297594,250183,216709,263556,189031,189081,189083,266102,124932,126478,178870,200043,200044,202494,207417,210413,210414,217663,251301,252220,260635,269004,75612,88748,107981,161940,167897,172456,173153,173199,176018,188828,198820,202914,203616,208960,208966,210192,211111,222707,222708,254744,260753,261523,263840,274418,281844,287289,287901,287927,288304,291745,291913,291915,298922,310318,104561,48879,220026,305251,266104,266667,266668,276043,48991,48996,94100,128458,167958,207408,207411,207412,217661,264523,151774,118272,198978,214067,266105,269847,106297,176019,178734,178735,200036,210465,217660,266653,286467,114137,252221,266626,118488,48730,48731,173205,173206,175803,200033,200035,200039,201749,217322,225702,225703,249745,252753,268639,272173,48828,48829,48840,48880,48995,64137,64138,209482,290160,290166,290165,209481,266554,269849,189087,269853,161359,170677,183666,225683,225684,247274,48992,48997,124634,290161,279263,118238,198979,48976,48977,74554,143967,49007,67720,67721,104706,111344,113768,117394,121556,121926,132032,132615,159192,159587,161852,170100,170101,172836,175668,183979,193461,201750,202262,215183,215184,221016,221025,225354,225365,225685,242407,246964,246986,247269,247271,247354,247543,250432,257307,261496,276640,277896,281228,281324,281617,282148,282173,283353,285171,285204,285384,285775,285803,285841,285959,286194,287583,288925,289827,290715,290794,290817,291091,291742,291743,291919,292038,297395,298052,299214,305002,310317,290706,157751,276181,276182,285308,285309,189084,122758,122759,122915,168856,202483,266661,189080,189088,118206,115867,132720,132721,170108,172451,175907,179407,179408,200032,225701,273804,287950,290803,122916,129342,151764,118191,118192,118195,118237,135601,137807,205849,269848,48987,68102,72185,115914,170285,173255,189733,167737,48993,49005,49009,49011,78739,278921,151775,151778,290157,290158,245580,201495,114624,138185,143007,175669,225692,244952,244957,247350,247351,203608,203610,189085,175908,266662,278922,48870,92315,111528,118883,128235,167736,168616,172457,172667,173201,179405,181559,189726,196786,199529,200034,200040,201011,210620,225303,242390,247352,249744,256117,268614,279974,281213,287573,289433,296578,298940,299193,302569,302570,302572,302573,302574,309318,309606,271961,271962,271974,271975,278229,260640,123628,173200,189728,189729,172030,117447,142883,144678,148608,155210,161939,163837,170107,172453,172666,204094,218300,218302,291746,292822,296408,299194,211300,158175,115177,124889,134640,134645,147435,147642,147840,147895,168536,175906,194077,197599,197602,203833,203838,207522,207973,246983,260769,281537,285184,305082,305099,45320,49002,49004,278919,278920,172862,175446,175449,150757,85487,134647,134648,151765,157750,158069,175734,201751,202803,209475,220421,228365,150758,205448,205835,100193,290181,116735,175729,48729,48732,67711,96872,107774,115738,122971,133164,139962,151767,151769,151770,151955,158514,161941,163874,164782,168540,172452,172455,172650,172796,173202,193074,197327,197604,197605,204109,207409,214089,218589,225292,225358,228585,246984,249742,249817,249818,251210,267809,267813,267815,267822,277888,277893,279988,280828,282158,282164,282182,283215,283629,285086,285090,285092,285425,285922,286281,291747,291923,292823,292826,292976,296409,298053,298743,299067,302575,305073,305104,309609,264364,264365,264909,264911,285482,285483,290177,290178,145195,172033,201496,201498,269831,215600,116860,147434,168973,182500,182504,182505,182506,207519,297888,115288,165384,168439,144682,130716,133569,133570,134637,134643,138481,145486,152013,165385,172714,175546,176030,181418,192956,200041,200042,203606,203607,205191,205192,205193,205623,205624,217844,260981,279991,280164,280868,285087,285091,287982,292848,292851,305052,305647,309317,130717,201492,201493,110381,134641,134644,134646,48735,48736,120379,165157,172665,189306,193462,200038,220419,249743,288044,292824,292827,296360,296410,84585,58807,79177,172913,179406,207525,208722,208723,210466,211138,218327,297251,118196,141538,142978,292574,292575,138157,157986,48734,48962,48963,48965,73343,73344,73345,73346,112084,113783,117878,119408,122332,123645,128793,133625,134176,137051,170781,172841,173493,175547,178666,181133,192759,202178,202179,205188,211041,213470,220720,220932,220991,227793,228461,228505,247804,267855,267877,268463,268622,268637,280862,281426,281727,282289,282619,283364,285089,285818,285856,286210,288055,290514,290653,290820,292849,292852,294760,294873,296616,297387,297394,298326,298941,299022,300769,300773,300775,300776,301150,305064,305078,305566,309591,132724,85488,134642,172696,205189,208724,292828,178869,143260,167833,169103,179412,192096,283352,285409,286586,290567,290599,290638,290698,292987,298946,300588,305627,107404,116856,132723,172649,172713,175075,192095,205102,205190,218564,218565,228459,245598,283366,285428,285430,285813,292850,292853,292986,294951,296626,297252,297407,299045,300762,305081,307692,307695,307798,307810,307892,309592,115143,143480,143481,137676,115142,48701,216883,203611,122792,128226,133828,172651,172721,179239,183662,197639,208202,222775,228460,228608,242093,242393,247761,267793,267806,267842,272108,278368,279989,280158,280836,280846,280855,280856,281158,281159,281374,281400,281732,281735,281746,285873,286307,287930,288061,288077,289770,290663,290711,290724,290753,290758,291971,292855,292856,293003,293105,294938,298965,298971,299046,299223,300590,301148,301307,304994,305028,305060,305088,305596,300750,108995,129398,132722,181563,73024,163276,242415,267787,282170,287903,290665,291046,293001,299002,299019,48699,76932,169230,179411,189361,163875,203603,121649,211586,222682,225305,242381,247533,267785,267786,267791,267795,267797,267869,277891,277895,280017,280019,280844,280853,280860,281365,281368,281377,281425,285347,285379,285410,285416,285427,285774,285780,285786,286308,287900,290502,290506,290730,290734,290739,290746,292996,292998,296454,296473,296630,297392,299307,307693,307754,288135,247534,280854,285188,285413,285930,150848,283356,287924,288890,290590,290749,290787,290825,298726,299006,299060,299308,307689,307698,307702,307894,118777,193439,215235,220974,220975,220982,220989,221035,225267,225283,228591,228599,228603,228613,247610,247813,281633,285201,285380,285381,285843,285880,285949,287922,287936,288052,288059,288078,289754,294940,297366,297374,297584,298054,298943,298944,299004,299005,299210,299220,299238,299325,300610,301341,301552,305061,305083,305556,305624,307897,309296,309299,309344,309351,309490,309493,309603,310319,111392,188229,220976,220984,220986,220988,220994,228593,285346,285492,288031,299322,301549,305606,307707,152910,66225,216708,296907,264674,264675,49025,161406,289232,122327,129286,48946,148141,69611,84399,147932,196395,219660,264913,285249,287291,296904,296905,306801,66435,49020,120896,170252,203618,216707,247322,281763,121874,277012,48943,48944,48945,65289,65290,65291,75189,120350,123330,126271,138138,179413,181572,201756,203617,206654,250088,296354,92765,92767,48930,99863,122866,158521,204314,209125,209486,274419,289556,169265,293450,157760,203515,48981,48941,48932,48935,79377,133339,135771,141296,49024,220309,161405,102277,49023,200024,207110,113780,147930,147931,196859,203384,206272,208945,208946,211572,270006,270007,48933,97139,147934,147933,148914)
get_typs (Datasource=, Time=15ms, Records=8) in E:\inetpub\wwwroot\category_sidenav_new.cfm @ 14:56:08.008
select distinct typ from getproducts1 where dept='Firearms' and brand='SMITH AND WESSON' group by typ order by sort_position
get_details (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\category_sidenav_new.cfm @ 14:56:08.008
select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Firearms' and typ='Blemished Guns' and subtyp_1='EMPTY' and site = 'sportsman'
get_details (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\category_sidenav_new.cfm @ 14:56:08.008
select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Firearms' and typ='Bolt Action Rifles' and subtyp_1='EMPTY' and site = 'sportsman'
get_details (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\category_sidenav_new.cfm @ 14:56:08.008
select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Firearms' and typ='Handgun Semi-Auto' and subtyp_1='EMPTY' and site = 'sportsman'
get_details (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\category_sidenav_new.cfm @ 14:56:08.008
select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Firearms' and typ='Lever Action' and subtyp_1='EMPTY' and site = 'sportsman'
get_details (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\category_sidenav_new.cfm @ 14:56:08.008
select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Firearms' and typ='Revolvers' and subtyp_1='EMPTY' and site = 'sportsman'
get_details (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\category_sidenav_new.cfm @ 14:56:08.008
select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Firearms' and typ='Semi-Auto Rifles' and subtyp_1='EMPTY' and site = 'sportsman'
get_details (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\category_sidenav_new.cfm @ 14:56:08.008
select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Firearms' and typ='Shotguns' and subtyp_1='EMPTY' and site = 'sportsman'
get_details (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\category_sidenav_new.cfm @ 14:56:08.008
select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Firearms' and typ='Used Gun Collection' and subtyp_1='EMPTY' and site = 'sportsman'
get_details (Datasource=celerantsql, Time=16ms, Records=1) in E:\inetpub\wwwroot\category_sidenav_new.cfm @ 14:56:08.008
select web_url, picture_id, web_taxonomy_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Guns with Color' and typ='EMPTY' and site = 'sportsman'
brand_product_lines (Datasource=celerantsql, Time=256ms, Records=0) in E:\inetpub\wwwroot\category_sidenav_new.cfm @ 14:56:08.008
select distinct a.spec_value 
                                from 
                                    tb_mfg_promo.dbo.item_spec_values a 
                                left join 
                                    tb_web_taxonomy b on (a.spec_dept=b.web_taxonomy_id) 
                                left join 
                                    tb_mfg_promo.dbo.item_specs c on (a.spec_value_id=c.spec_value_id)
                                where 
                                    a.spec_dept = 795 and c.style_id in (189730,281768,203612,281769,134629,65231,48910,48914,48904,48916,81637,117757,48920,136427,133827,132542,48919,79472,189732,290173,290174,283158,290155,117429,48852,48854,48856,48858,203264,266679,266680,48752,48753,134627,157795,48912,107147,176008,205461,122572,106685,106998,48907,109732,48855,48898,220624,118279,118280,137838,97803,102178,122753,134630,112488,48896,266677,48918,123314,134628,75112,92111,48897,204789,285199,48767,178652,48845,122725,256908,134639,134626,95261,67716,149555,189731,207415,203613,64013,94699,119298,122752,269303,48794,114322,302079,134638,189711,48792,48786,73371,203593,203594,48923,48925,216705,73370,203599,266671,173191,193310,281263,48835,48837,48865,48866,49016,112396,114169,218295,218297,49057,278917,278911,108394,216706,256810,48766,260751,302760,302761,304769,48860,48862,272113,245691,48787,49050,103256,106999,173190,218298,266696,269823,277892,280196,281225,288887,125473,118282,116877,118581,178923,220030,220031,269843,269845,118281,118177,118189,145505,197052,115146,115382,117859,136017,150690,112486,269844,134634,207423,299119,48883,48884,48885,48892,134635,189721,189723,286627,286628,290170,290171,129037,105744,121254,123307,207414,215028,269842,189714,189716,189717,218308,48802,48804,109580,48886,48887,49015,192097,112487,48810,108064,137806,173193,204092,212067,217689,218305,242411,279957,280154,281189,281541,285345,290720,49014,48834,49055,298175,134636,266672,266673,266674,266675,266676,100197,212059,218303,218304,263845,48924,172794,266101,135600,142979,143193,143674,143801,185556,266669,269839,48864,111248,173189,207421,212051,212065,252391,288659,122751,269852,118187,112809,144010,147157,269838,212055,48772,99082,222706,269850,181361,48711,253027,307658,307659,48798,48800,48818,48820,209140,217662,118241,48713,136716,192093,218299,247280,247283,249746,283677,284842,289326,302759,260639,164551,247315,147161,173198,192094,207207,247286,48819,48875,118172,247276,274257,48831,48881,72176,106174,118277,290169,286650,247281,263847,48844,64010,109162,166590,173211,200023,213979,279942,287197,293016,302756,282715,266664,170303,247279,97510,111009,164552,266660,269837,264807,48841,170109,170286,181558,287198,302754,118173,157861,266665,281767,48888,151002,151003,173208,208686,218306,218307,247275,247277,167637,109731,118273,118203,250676,266658,125806,173183,173188,211795,213976,246992,247287,247289,247774,249809,281622,286229,287572,291089,292239,297991,303813,266657,142970,143767,248799,290017,138569,173180,173181,173184,205745,205746,207420,207422,211580,247278,254127,254128,261495,297563,104547,128766,148355,148697,210190,151004,151005,296422,147786,266663,148350,151783,247284,118188,197597,198698,200025,211798,213978,255630,289362,291744,287551,287552,288192,288193,264809,173192,218435,251298,251302,260583,266843,309514,302755,173212,178650,185645,188815,204098,212056,250016,251303,111301,86512,122917,168857,124931,203615,118271,170287,173256,48799,75401,103424,105625,110113,173152,183615,188831,198821,198822,202309,202495,207416,207418,207419,211797,212048,212060,213977,215419,217659,246985,246987,247260,248842,251299,252017,263843,267979,285439,288590,305632,133442,203614,273262,273263,276185,276186,289976,289986,293284,173186,188829,189734,198823,202801,202802,251300,252922,296903,132361,273250,273255,276183,276184,279521,279525,279641,290168,290172,189089,189090,274153,278938,269846,48824,48986,79833,188820,189461,212052,247648,296902,310316,269851,118240,278923,278924,250198,251012,212028,48921,91942,176031,218301,263839,296901,264912,266241,297594,250183,216709,263556,189031,189081,189083,266102,124932,126478,178870,200043,200044,202494,207417,210413,210414,217663,251301,252220,260635,269004,75612,88748,107981,161940,167897,172456,173153,173199,176018,188828,198820,202914,203616,208960,208966,210192,211111,222707,222708,254744,260753,261523,263840,274418,281844,287289,287901,287927,288304,291745,291913,291915,298922,310318,104561,48879,220026,305251,266104,266667,266668,276043,48991,48996,94100,128458,167958,207408,207411,207412,217661,264523,151774,118272,198978,214067,266105,269847,106297,176019,178734,178735,200036,210465,217660,266653,286467,114137,252221,266626,118488,48730,48731,173205,173206,175803,200033,200035,200039,201749,217322,225702,225703,249745,252753,268639,272173,48828,48829,48840,48880,48995,64137,64138,209482,290160,290166,290165,209481,266554,269849,189087,269853,161359,170677,183666,225683,225684,247274,48992,48997,124634,290161,279263,118238,198979,48976,48977,74554,143967,49007,67720,67721,104706,111344,113768,117394,121556,121926,132032,132615,159192,159587,161852,170100,170101,172836,175668,183979,193461,201750,202262,215183,215184,221016,221025,225354,225365,225685,242407,246964,246986,247269,247271,247354,247543,250432,257307,261496,276640,277896,281228,281324,281617,282148,282173,283353,285171,285204,285384,285775,285803,285841,285959,286194,287583,288925,289827,290715,290794,290817,291091,291742,291743,291919,292038,297395,298052,299214,305002,310317,290706,157751,276181,276182,285308,285309,189084,122758,122759,122915,168856,202483,266661,189080,189088,118206,115867,132720,132721,170108,172451,175907,179407,179408,200032,225701,273804,287950,290803,122916,129342,151764,118191,118192,118195,118237,135601,137807,205849,269848,48987,68102,72185,115914,170285,173255,189733,167737,48993,49005,49009,49011,78739,278921,151775,151778,290157,290158,245580,201495,114624,138185,143007,175669,225692,244952,244957,247350,247351,203608,203610,189085,175908,266662,278922,48870,92315,111528,118883,128235,167736,168616,172457,172667,173201,179405,181559,189726,196786,199529,200034,200040,201011,210620,225303,242390,247352,249744,256117,268614,279974,281213,287573,289433,296578,298940,299193,302569,302570,302572,302573,302574,309318,309606,271961,271962,271974,271975,278229,260640,123628,173200,189728,189729,172030,117447,142883,144678,148608,155210,161939,163837,170107,172453,172666,204094,218300,218302,291746,292822,296408,299194,211300,158175,115177,124889,134640,134645,147435,147642,147840,147895,168536,175906,194077,197599,197602,203833,203838,207522,207973,246983,260769,281537,285184,305082,305099,45320,49002,49004,278919,278920,172862,175446,175449,150757,85487,134647,134648,151765,157750,158069,175734,201751,202803,209475,220421,228365,150758,205448,205835,100193,290181,116735,175729,48729,48732,67711,96872,107774,115738,122971,133164,139962,151767,151769,151770,151955,158514,161941,163874,164782,168540,172452,172455,172650,172796,173202,193074,197327,197604,197605,204109,207409,214089,218589,225292,225358,228585,246984,249742,249817,249818,251210,267809,267813,267815,267822,277888,277893,279988,280828,282158,282164,282182,283215,283629,285086,285090,285092,285425,285922,286281,291747,291923,292823,292826,292976,296409,298053,298743,299067,302575,305073,305104,309609,264364,264365,264909,264911,285482,285483,290177,290178,145195,172033,201496,201498,269831,215600,116860,147434,168973,182500,182504,182505,182506,207519,297888,115288,165384,168439,144682,130716,133569,133570,134637,134643,138481,145486,152013,165385,172714,175546,176030,181418,192956,200041,200042,203606,203607,205191,205192,205193,205623,205624,217844,260981,279991,280164,280868,285087,285091,287982,292848,292851,305052,305647,309317,130717,201492,201493,110381,134641,134644,134646,48735,48736,120379,165157,172665,189306,193462,200038,220419,249743,288044,292824,292827,296360,296410,84585,58807,79177,172913,179406,207525,208722,208723,210466,211138,218327,297251,118196,141538,142978,292574,292575,138157,157986,48734,48962,48963,48965,73343,73344,73345,73346,112084,113783,117878,119408,122332,123645,128793,133625,134176,137051,170781,172841,173493,175547,178666,181133,192759,202178,202179,205188,211041,213470,220720,220932,220991,227793,228461,228505,247804,267855,267877,268463,268622,268637,280862,281426,281727,282289,282619,283364,285089,285818,285856,286210,288055,290514,290653,290820,292849,292852,294760,294873,296616,297387,297394,298326,298941,299022,300769,300773,300775,300776,301150,305064,305078,305566,309591,132724,85488,134642,172696,205189,208724,292828,178869,143260,167833,169103,179412,192096,283352,285409,286586,290567,290599,290638,290698,292987,298946,300588,305627,107404,116856,132723,172649,172713,175075,192095,205102,205190,218564,218565,228459,245598,283366,285428,285430,285813,292850,292853,292986,294951,296626,297252,297407,299045,300762,305081,307692,307695,307798,307810,307892,309592,115143,143480,143481,137676,115142,48701,216883,203611,122792,128226,133828,172651,172721,179239,183662,197639,208202,222775,228460,228608,242093,242393,247761,267793,267806,267842,272108,278368,279989,280158,280836,280846,280855,280856,281158,281159,281374,281400,281732,281735,281746,285873,286307,287930,288061,288077,289770,290663,290711,290724,290753,290758,291971,292855,292856,293003,293105,294938,298965,298971,299046,299223,300590,301148,301307,304994,305028,305060,305088,305596,300750,108995,129398,132722,181563,73024,163276,242415,267787,282170,287903,290665,291046,293001,299002,299019,48699,76932,169230,179411,189361,163875,203603,121649,211586,222682,225305,242381,247533,267785,267786,267791,267795,267797,267869,277891,277895,280017,280019,280844,280853,280860,281365,281368,281377,281425,285347,285379,285410,285416,285427,285774,285780,285786,286308,287900,290502,290506,290730,290734,290739,290746,292996,292998,296454,296473,296630,297392,299307,307693,307754,288135,247534,280854,285188,285413,285930,150848,283356,287924,288890,290590,290749,290787,290825,298726,299006,299060,299308,307689,307698,307702,307894,118777,193439,215235,220974,220975,220982,220989,221035,225267,225283,228591,228599,228603,228613,247610,247813,281633,285201,285380,285381,285843,285880,285949,287922,287936,288052,288059,288078,289754,294940,297366,297374,297584,298054,298943,298944,299004,299005,299210,299220,299238,299325,300610,301341,301552,305061,305083,305556,305624,307897,309296,309299,309344,309351,309490,309493,309603,310319,111392,188229,220976,220984,220986,220988,220994,228593,285346,285492,288031,299322,301549,305606,307707,152910,66225,216708,296907,264674,264675,49025,161406,289232,122327,129286,48946,148141,69611,84399,147932,196395,219660,264913,285249,287291,296904,296905,306801,66435,49020,120896,170252,203618,216707,247322,281763,121874,277012,48943,48944,48945,65289,65290,65291,75189,120350,123330,126271,138138,179413,181572,201756,203617,206654,250088,296354,92765,92767,48930,99863,122866,158521,204314,209125,209486,274419,289556,169265,293450,157760,203515,48981,48941,48932,48935,79377,133339,135771,141296,49024,220309,161405,102277,49023,200024,207110,113780,147930,147931,196859,203384,206272,208945,208946,211572,270006,270007,48933,97139,147934,147933,148914)
get_typs (Datasource=, Time=0ms, Records=3) in E:\inetpub\wwwroot\category_sidenav_new.cfm @ 14:56:08.008
select distinct typ from getproducts1 where dept='Guns with Color' and brand='SMITH AND WESSON' group by typ order by sort_position
get_details (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\category_sidenav_new.cfm @ 14:56:08.008
select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Guns with Color' and typ='Pistols with Color' and subtyp_1='EMPTY' and site = 'sportsman'
get_details (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\category_sidenav_new.cfm @ 14:56:08.008
select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Guns with Color' and typ='Revolvers with Color' and subtyp_1='EMPTY' and site = 'sportsman'
get_details (Datasource=celerantsql, Time=16ms, Records=1) in E:\inetpub\wwwroot\category_sidenav_new.cfm @ 14:56:08.008
select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Guns with Color' and typ='Rifles with Color' and subtyp_1='EMPTY' and site = 'sportsman'
get_details (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\category_sidenav_new.cfm @ 14:56:08.008
select web_url, picture_id, web_taxonomy_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Law Enforcement' and typ='EMPTY' and site = 'sportsman'
brand_product_lines (Datasource=celerantsql, Time=189ms, Records=0) in E:\inetpub\wwwroot\category_sidenav_new.cfm @ 14:56:08.008
select distinct a.spec_value 
                                from 
                                    tb_mfg_promo.dbo.item_spec_values a 
                                left join 
                                    tb_web_taxonomy b on (a.spec_dept=b.web_taxonomy_id) 
                                left join 
                                    tb_mfg_promo.dbo.item_specs c on (a.spec_value_id=c.spec_value_id)
                                where 
                                    a.spec_dept = 29 and c.style_id in (189730,281768,203612,281769,134629,65231,48910,48914,48904,48916,81637,117757,48920,136427,133827,132542,48919,79472,189732,290173,290174,283158,290155,117429,48852,48854,48856,48858,203264,266679,266680,48752,48753,134627,157795,48912,107147,176008,205461,122572,106685,106998,48907,109732,48855,48898,220624,118279,118280,137838,97803,102178,122753,134630,112488,48896,266677,48918,123314,134628,75112,92111,48897,204789,285199,48767,178652,48845,122725,256908,134639,134626,95261,67716,149555,189731,207415,203613,64013,94699,119298,122752,269303,48794,114322,302079,134638,189711,48792,48786,73371,203593,203594,48923,48925,216705,73370,203599,266671,173191,193310,281263,48835,48837,48865,48866,49016,112396,114169,218295,218297,49057,278917,278911,108394,216706,256810,48766,260751,302760,302761,304769,48860,48862,272113,245691,48787,49050,103256,106999,173190,218298,266696,269823,277892,280196,281225,288887,125473,118282,116877,118581,178923,220030,220031,269843,269845,118281,118177,118189,145505,197052,115146,115382,117859,136017,150690,112486,269844,134634,207423,299119,48883,48884,48885,48892,134635,189721,189723,286627,286628,290170,290171,129037,105744,121254,123307,207414,215028,269842,189714,189716,189717,218308,48802,48804,109580,48886,48887,49015,192097,112487,48810,108064,137806,173193,204092,212067,217689,218305,242411,279957,280154,281189,281541,285345,290720,49014,48834,49055,298175,134636,266672,266673,266674,266675,266676,100197,212059,218303,218304,263845,48924,172794,266101,135600,142979,143193,143674,143801,185556,266669,269839,48864,111248,173189,207421,212051,212065,252391,288659,122751,269852,118187,112809,144010,147157,269838,212055,48772,99082,222706,269850,181361,48711,253027,307658,307659,48798,48800,48818,48820,209140,217662,118241,48713,136716,192093,218299,247280,247283,249746,283677,284842,289326,302759,260639,164551,247315,147161,173198,192094,207207,247286,48819,48875,118172,247276,274257,48831,48881,72176,106174,118277,290169,286650,247281,263847,48844,64010,109162,166590,173211,200023,213979,279942,287197,293016,302756,282715,266664,170303,247279,97510,111009,164552,266660,269837,264807,48841,170109,170286,181558,287198,302754,118173,157861,266665,281767,48888,151002,151003,173208,208686,218306,218307,247275,247277,167637,109731,118273,118203,250676,266658,125806,173183,173188,211795,213976,246992,247287,247289,247774,249809,281622,286229,287572,291089,292239,297991,303813,266657,142970,143767,248799,290017,138569,173180,173181,173184,205745,205746,207420,207422,211580,247278,254127,254128,261495,297563,104547,128766,148355,148697,210190,151004,151005,296422,147786,266663,148350,151783,247284,118188,197597,198698,200025,211798,213978,255630,289362,291744,287551,287552,288192,288193,264809,173192,218435,251298,251302,260583,266843,309514,302755,173212,178650,185645,188815,204098,212056,250016,251303,111301,86512,122917,168857,124931,203615,118271,170287,173256,48799,75401,103424,105625,110113,173152,183615,188831,198821,198822,202309,202495,207416,207418,207419,211797,212048,212060,213977,215419,217659,246985,246987,247260,248842,251299,252017,263843,267979,285439,288590,305632,133442,203614,273262,273263,276185,276186,289976,289986,293284,173186,188829,189734,198823,202801,202802,251300,252922,296903,132361,273250,273255,276183,276184,279521,279525,279641,290168,290172,189089,189090,274153,278938,269846,48824,48986,79833,188820,189461,212052,247648,296902,310316,269851,118240,278923,278924,250198,251012,212028,48921,91942,176031,218301,263839,296901,264912,266241,297594,250183,216709,263556,189031,189081,189083,266102,124932,126478,178870,200043,200044,202494,207417,210413,210414,217663,251301,252220,260635,269004,75612,88748,107981,161940,167897,172456,173153,173199,176018,188828,198820,202914,203616,208960,208966,210192,211111,222707,222708,254744,260753,261523,263840,274418,281844,287289,287901,287927,288304,291745,291913,291915,298922,310318,104561,48879,220026,305251,266104,266667,266668,276043,48991,48996,94100,128458,167958,207408,207411,207412,217661,264523,151774,118272,198978,214067,266105,269847,106297,176019,178734,178735,200036,210465,217660,266653,286467,114137,252221,266626,118488,48730,48731,173205,173206,175803,200033,200035,200039,201749,217322,225702,225703,249745,252753,268639,272173,48828,48829,48840,48880,48995,64137,64138,209482,290160,290166,290165,209481,266554,269849,189087,269853,161359,170677,183666,225683,225684,247274,48992,48997,124634,290161,279263,118238,198979,48976,48977,74554,143967,49007,67720,67721,104706,111344,113768,117394,121556,121926,132032,132615,159192,159587,161852,170100,170101,172836,175668,183979,193461,201750,202262,215183,215184,221016,221025,225354,225365,225685,242407,246964,246986,247269,247271,247354,247543,250432,257307,261496,276640,277896,281228,281324,281617,282148,282173,283353,285171,285204,285384,285775,285803,285841,285959,286194,287583,288925,289827,290715,290794,290817,291091,291742,291743,291919,292038,297395,298052,299214,305002,310317,290706,157751,276181,276182,285308,285309,189084,122758,122759,122915,168856,202483,266661,189080,189088,118206,115867,132720,132721,170108,172451,175907,179407,179408,200032,225701,273804,287950,290803,122916,129342,151764,118191,118192,118195,118237,135601,137807,205849,269848,48987,68102,72185,115914,170285,173255,189733,167737,48993,49005,49009,49011,78739,278921,151775,151778,290157,290158,245580,201495,114624,138185,143007,175669,225692,244952,244957,247350,247351,203608,203610,189085,175908,266662,278922,48870,92315,111528,118883,128235,167736,168616,172457,172667,173201,179405,181559,189726,196786,199529,200034,200040,201011,210620,225303,242390,247352,249744,256117,268614,279974,281213,287573,289433,296578,298940,299193,302569,302570,302572,302573,302574,309318,309606,271961,271962,271974,271975,278229,260640,123628,173200,189728,189729,172030,117447,142883,144678,148608,155210,161939,163837,170107,172453,172666,204094,218300,218302,291746,292822,296408,299194,211300,158175,115177,124889,134640,134645,147435,147642,147840,147895,168536,175906,194077,197599,197602,203833,203838,207522,207973,246983,260769,281537,285184,305082,305099,45320,49002,49004,278919,278920,172862,175446,175449,150757,85487,134647,134648,151765,157750,158069,175734,201751,202803,209475,220421,228365,150758,205448,205835,100193,290181,116735,175729,48729,48732,67711,96872,107774,115738,122971,133164,139962,151767,151769,151770,151955,158514,161941,163874,164782,168540,172452,172455,172650,172796,173202,193074,197327,197604,197605,204109,207409,214089,218589,225292,225358,228585,246984,249742,249817,249818,251210,267809,267813,267815,267822,277888,277893,279988,280828,282158,282164,282182,283215,283629,285086,285090,285092,285425,285922,286281,291747,291923,292823,292826,292976,296409,298053,298743,299067,302575,305073,305104,309609,264364,264365,264909,264911,285482,285483,290177,290178,145195,172033,201496,201498,269831,215600,116860,147434,168973,182500,182504,182505,182506,207519,297888,115288,165384,168439,144682,130716,133569,133570,134637,134643,138481,145486,152013,165385,172714,175546,176030,181418,192956,200041,200042,203606,203607,205191,205192,205193,205623,205624,217844,260981,279991,280164,280868,285087,285091,287982,292848,292851,305052,305647,309317,130717,201492,201493,110381,134641,134644,134646,48735,48736,120379,165157,172665,189306,193462,200038,220419,249743,288044,292824,292827,296360,296410,84585,58807,79177,172913,179406,207525,208722,208723,210466,211138,218327,297251,118196,141538,142978,292574,292575,138157,157986,48734,48962,48963,48965,73343,73344,73345,73346,112084,113783,117878,119408,122332,123645,128793,133625,134176,137051,170781,172841,173493,175547,178666,181133,192759,202178,202179,205188,211041,213470,220720,220932,220991,227793,228461,228505,247804,267855,267877,268463,268622,268637,280862,281426,281727,282289,282619,283364,285089,285818,285856,286210,288055,290514,290653,290820,292849,292852,294760,294873,296616,297387,297394,298326,298941,299022,300769,300773,300775,300776,301150,305064,305078,305566,309591,132724,85488,134642,172696,205189,208724,292828,178869,143260,167833,169103,179412,192096,283352,285409,286586,290567,290599,290638,290698,292987,298946,300588,305627,107404,116856,132723,172649,172713,175075,192095,205102,205190,218564,218565,228459,245598,283366,285428,285430,285813,292850,292853,292986,294951,296626,297252,297407,299045,300762,305081,307692,307695,307798,307810,307892,309592,115143,143480,143481,137676,115142,48701,216883,203611,122792,128226,133828,172651,172721,179239,183662,197639,208202,222775,228460,228608,242093,242393,247761,267793,267806,267842,272108,278368,279989,280158,280836,280846,280855,280856,281158,281159,281374,281400,281732,281735,281746,285873,286307,287930,288061,288077,289770,290663,290711,290724,290753,290758,291971,292855,292856,293003,293105,294938,298965,298971,299046,299223,300590,301148,301307,304994,305028,305060,305088,305596,300750,108995,129398,132722,181563,73024,163276,242415,267787,282170,287903,290665,291046,293001,299002,299019,48699,76932,169230,179411,189361,163875,203603,121649,211586,222682,225305,242381,247533,267785,267786,267791,267795,267797,267869,277891,277895,280017,280019,280844,280853,280860,281365,281368,281377,281425,285347,285379,285410,285416,285427,285774,285780,285786,286308,287900,290502,290506,290730,290734,290739,290746,292996,292998,296454,296473,296630,297392,299307,307693,307754,288135,247534,280854,285188,285413,285930,150848,283356,287924,288890,290590,290749,290787,290825,298726,299006,299060,299308,307689,307698,307702,307894,118777,193439,215235,220974,220975,220982,220989,221035,225267,225283,228591,228599,228603,228613,247610,247813,281633,285201,285380,285381,285843,285880,285949,287922,287936,288052,288059,288078,289754,294940,297366,297374,297584,298054,298943,298944,299004,299005,299210,299220,299238,299325,300610,301341,301552,305061,305083,305556,305624,307897,309296,309299,309344,309351,309490,309493,309603,310319,111392,188229,220976,220984,220986,220988,220994,228593,285346,285492,288031,299322,301549,305606,307707,152910,66225,216708,296907,264674,264675,49025,161406,289232,122327,129286,48946,148141,69611,84399,147932,196395,219660,264913,285249,287291,296904,296905,306801,66435,49020,120896,170252,203618,216707,247322,281763,121874,277012,48943,48944,48945,65289,65290,65291,75189,120350,123330,126271,138138,179413,181572,201756,203617,206654,250088,296354,92765,92767,48930,99863,122866,158521,204314,209125,209486,274419,289556,169265,293450,157760,203515,48981,48941,48932,48935,79377,133339,135771,141296,49024,220309,161405,102277,49023,200024,207110,113780,147930,147931,196859,203384,206272,208945,208946,211572,270006,270007,48933,97139,147934,147933,148914)
get_typs (Datasource=, Time=0ms, Records=4) in E:\inetpub\wwwroot\category_sidenav_new.cfm @ 14:56:08.008
select distinct typ from getproducts1 where dept='Law Enforcement' and brand='SMITH AND WESSON' group by typ order by sort_position
get_details (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\category_sidenav_new.cfm @ 14:56:08.008
select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Law Enforcement' and typ='Handguns' and subtyp_1='EMPTY' and site = 'sportsman'
get_details (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\category_sidenav_new.cfm @ 14:56:08.008
select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Law Enforcement' and typ='Rifles' and subtyp_1='EMPTY' and site = 'sportsman'
get_details (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\category_sidenav_new.cfm @ 14:56:08.008
select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Law Enforcement' and typ='Shotguns' and subtyp_1='EMPTY' and site = 'sportsman'
get_details (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\category_sidenav_new.cfm @ 14:56:08.008
select web_url, picture_id, web_taxonomy_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Smith & Wesson' and typ='EMPTY' and site = 'sportsman'
brand_product_lines (Datasource=celerantsql, Time=158ms, Records=0) in E:\inetpub\wwwroot\category_sidenav_new.cfm @ 14:56:08.008
select distinct a.spec_value 
                                from 
                                    tb_mfg_promo.dbo.item_spec_values a 
                                left join 
                                    tb_web_taxonomy b on (a.spec_dept=b.web_taxonomy_id) 
                                left join 
                                    tb_mfg_promo.dbo.item_specs c on (a.spec_value_id=c.spec_value_id)
                                where 
                                    a.spec_dept = 817 and c.style_id in (189730,281768,203612,281769,134629,65231,48910,48914,48904,48916,81637,117757,48920,136427,133827,132542,48919,79472,189732,290173,290174,283158,290155,117429,48852,48854,48856,48858,203264,266679,266680,48752,48753,134627,157795,48912,107147,176008,205461,122572,106685,106998,48907,109732,48855,48898,220624,118279,118280,137838,97803,102178,122753,134630,112488,48896,266677,48918,123314,134628,75112,92111,48897,204789,285199,48767,178652,48845,122725,256908,134639,134626,95261,67716,149555,189731,207415,203613,64013,94699,119298,122752,269303,48794,114322,302079,134638,189711,48792,48786,73371,203593,203594,48923,48925,216705,73370,203599,266671,173191,193310,281263,48835,48837,48865,48866,49016,112396,114169,218295,218297,49057,278917,278911,108394,216706,256810,48766,260751,302760,302761,304769,48860,48862,272113,245691,48787,49050,103256,106999,173190,218298,266696,269823,277892,280196,281225,288887,125473,118282,116877,118581,178923,220030,220031,269843,269845,118281,118177,118189,145505,197052,115146,115382,117859,136017,150690,112486,269844,134634,207423,299119,48883,48884,48885,48892,134635,189721,189723,286627,286628,290170,290171,129037,105744,121254,123307,207414,215028,269842,189714,189716,189717,218308,48802,48804,109580,48886,48887,49015,192097,112487,48810,108064,137806,173193,204092,212067,217689,218305,242411,279957,280154,281189,281541,285345,290720,49014,48834,49055,298175,134636,266672,266673,266674,266675,266676,100197,212059,218303,218304,263845,48924,172794,266101,135600,142979,143193,143674,143801,185556,266669,269839,48864,111248,173189,207421,212051,212065,252391,288659,122751,269852,118187,112809,144010,147157,269838,212055,48772,99082,222706,269850,181361,48711,253027,307658,307659,48798,48800,48818,48820,209140,217662,118241,48713,136716,192093,218299,247280,247283,249746,283677,284842,289326,302759,260639,164551,247315,147161,173198,192094,207207,247286,48819,48875,118172,247276,274257,48831,48881,72176,106174,118277,290169,286650,247281,263847,48844,64010,109162,166590,173211,200023,213979,279942,287197,293016,302756,282715,266664,170303,247279,97510,111009,164552,266660,269837,264807,48841,170109,170286,181558,287198,302754,118173,157861,266665,281767,48888,151002,151003,173208,208686,218306,218307,247275,247277,167637,109731,118273,118203,250676,266658,125806,173183,173188,211795,213976,246992,247287,247289,247774,249809,281622,286229,287572,291089,292239,297991,303813,266657,142970,143767,248799,290017,138569,173180,173181,173184,205745,205746,207420,207422,211580,247278,254127,254128,261495,297563,104547,128766,148355,148697,210190,151004,151005,296422,147786,266663,148350,151783,247284,118188,197597,198698,200025,211798,213978,255630,289362,291744,287551,287552,288192,288193,264809,173192,218435,251298,251302,260583,266843,309514,302755,173212,178650,185645,188815,204098,212056,250016,251303,111301,86512,122917,168857,124931,203615,118271,170287,173256,48799,75401,103424,105625,110113,173152,183615,188831,198821,198822,202309,202495,207416,207418,207419,211797,212048,212060,213977,215419,217659,246985,246987,247260,248842,251299,252017,263843,267979,285439,288590,305632,133442,203614,273262,273263,276185,276186,289976,289986,293284,173186,188829,189734,198823,202801,202802,251300,252922,296903,132361,273250,273255,276183,276184,279521,279525,279641,290168,290172,189089,189090,274153,278938,269846,48824,48986,79833,188820,189461,212052,247648,296902,310316,269851,118240,278923,278924,250198,251012,212028,48921,91942,176031,218301,263839,296901,264912,266241,297594,250183,216709,263556,189031,189081,189083,266102,124932,126478,178870,200043,200044,202494,207417,210413,210414,217663,251301,252220,260635,269004,75612,88748,107981,161940,167897,172456,173153,173199,176018,188828,198820,202914,203616,208960,208966,210192,211111,222707,222708,254744,260753,261523,263840,274418,281844,287289,287901,287927,288304,291745,291913,291915,298922,310318,104561,48879,220026,305251,266104,266667,266668,276043,48991,48996,94100,128458,167958,207408,207411,207412,217661,264523,151774,118272,198978,214067,266105,269847,106297,176019,178734,178735,200036,210465,217660,266653,286467,114137,252221,266626,118488,48730,48731,173205,173206,175803,200033,200035,200039,201749,217322,225702,225703,249745,252753,268639,272173,48828,48829,48840,48880,48995,64137,64138,209482,290160,290166,290165,209481,266554,269849,189087,269853,161359,170677,183666,225683,225684,247274,48992,48997,124634,290161,279263,118238,198979,48976,48977,74554,143967,49007,67720,67721,104706,111344,113768,117394,121556,121926,132032,132615,159192,159587,161852,170100,170101,172836,175668,183979,193461,201750,202262,215183,215184,221016,221025,225354,225365,225685,242407,246964,246986,247269,247271,247354,247543,250432,257307,261496,276640,277896,281228,281324,281617,282148,282173,283353,285171,285204,285384,285775,285803,285841,285959,286194,287583,288925,289827,290715,290794,290817,291091,291742,291743,291919,292038,297395,298052,299214,305002,310317,290706,157751,276181,276182,285308,285309,189084,122758,122759,122915,168856,202483,266661,189080,189088,118206,115867,132720,132721,170108,172451,175907,179407,179408,200032,225701,273804,287950,290803,122916,129342,151764,118191,118192,118195,118237,135601,137807,205849,269848,48987,68102,72185,115914,170285,173255,189733,167737,48993,49005,49009,49011,78739,278921,151775,151778,290157,290158,245580,201495,114624,138185,143007,175669,225692,244952,244957,247350,247351,203608,203610,189085,175908,266662,278922,48870,92315,111528,118883,128235,167736,168616,172457,172667,173201,179405,181559,189726,196786,199529,200034,200040,201011,210620,225303,242390,247352,249744,256117,268614,279974,281213,287573,289433,296578,298940,299193,302569,302570,302572,302573,302574,309318,309606,271961,271962,271974,271975,278229,260640,123628,173200,189728,189729,172030,117447,142883,144678,148608,155210,161939,163837,170107,172453,172666,204094,218300,218302,291746,292822,296408,299194,211300,158175,115177,124889,134640,134645,147435,147642,147840,147895,168536,175906,194077,197599,197602,203833,203838,207522,207973,246983,260769,281537,285184,305082,305099,45320,49002,49004,278919,278920,172862,175446,175449,150757,85487,134647,134648,151765,157750,158069,175734,201751,202803,209475,220421,228365,150758,205448,205835,100193,290181,116735,175729,48729,48732,67711,96872,107774,115738,122971,133164,139962,151767,151769,151770,151955,158514,161941,163874,164782,168540,172452,172455,172650,172796,173202,193074,197327,197604,197605,204109,207409,214089,218589,225292,225358,228585,246984,249742,249817,249818,251210,267809,267813,267815,267822,277888,277893,279988,280828,282158,282164,282182,283215,283629,285086,285090,285092,285425,285922,286281,291747,291923,292823,292826,292976,296409,298053,298743,299067,302575,305073,305104,309609,264364,264365,264909,264911,285482,285483,290177,290178,145195,172033,201496,201498,269831,215600,116860,147434,168973,182500,182504,182505,182506,207519,297888,115288,165384,168439,144682,130716,133569,133570,134637,134643,138481,145486,152013,165385,172714,175546,176030,181418,192956,200041,200042,203606,203607,205191,205192,205193,205623,205624,217844,260981,279991,280164,280868,285087,285091,287982,292848,292851,305052,305647,309317,130717,201492,201493,110381,134641,134644,134646,48735,48736,120379,165157,172665,189306,193462,200038,220419,249743,288044,292824,292827,296360,296410,84585,58807,79177,172913,179406,207525,208722,208723,210466,211138,218327,297251,118196,141538,142978,292574,292575,138157,157986,48734,48962,48963,48965,73343,73344,73345,73346,112084,113783,117878,119408,122332,123645,128793,133625,134176,137051,170781,172841,173493,175547,178666,181133,192759,202178,202179,205188,211041,213470,220720,220932,220991,227793,228461,228505,247804,267855,267877,268463,268622,268637,280862,281426,281727,282289,282619,283364,285089,285818,285856,286210,288055,290514,290653,290820,292849,292852,294760,294873,296616,297387,297394,298326,298941,299022,300769,300773,300775,300776,301150,305064,305078,305566,309591,132724,85488,134642,172696,205189,208724,292828,178869,143260,167833,169103,179412,192096,283352,285409,286586,290567,290599,290638,290698,292987,298946,300588,305627,107404,116856,132723,172649,172713,175075,192095,205102,205190,218564,218565,228459,245598,283366,285428,285430,285813,292850,292853,292986,294951,296626,297252,297407,299045,300762,305081,307692,307695,307798,307810,307892,309592,115143,143480,143481,137676,115142,48701,216883,203611,122792,128226,133828,172651,172721,179239,183662,197639,208202,222775,228460,228608,242093,242393,247761,267793,267806,267842,272108,278368,279989,280158,280836,280846,280855,280856,281158,281159,281374,281400,281732,281735,281746,285873,286307,287930,288061,288077,289770,290663,290711,290724,290753,290758,291971,292855,292856,293003,293105,294938,298965,298971,299046,299223,300590,301148,301307,304994,305028,305060,305088,305596,300750,108995,129398,132722,181563,73024,163276,242415,267787,282170,287903,290665,291046,293001,299002,299019,48699,76932,169230,179411,189361,163875,203603,121649,211586,222682,225305,242381,247533,267785,267786,267791,267795,267797,267869,277891,277895,280017,280019,280844,280853,280860,281365,281368,281377,281425,285347,285379,285410,285416,285427,285774,285780,285786,286308,287900,290502,290506,290730,290734,290739,290746,292996,292998,296454,296473,296630,297392,299307,307693,307754,288135,247534,280854,285188,285413,285930,150848,283356,287924,288890,290590,290749,290787,290825,298726,299006,299060,299308,307689,307698,307702,307894,118777,193439,215235,220974,220975,220982,220989,221035,225267,225283,228591,228599,228603,228613,247610,247813,281633,285201,285380,285381,285843,285880,285949,287922,287936,288052,288059,288078,289754,294940,297366,297374,297584,298054,298943,298944,299004,299005,299210,299220,299238,299325,300610,301341,301552,305061,305083,305556,305624,307897,309296,309299,309344,309351,309490,309493,309603,310319,111392,188229,220976,220984,220986,220988,220994,228593,285346,285492,288031,299322,301549,305606,307707,152910,66225,216708,296907,264674,264675,49025,161406,289232,122327,129286,48946,148141,69611,84399,147932,196395,219660,264913,285249,287291,296904,296905,306801,66435,49020,120896,170252,203618,216707,247322,281763,121874,277012,48943,48944,48945,65289,65290,65291,75189,120350,123330,126271,138138,179413,181572,201756,203617,206654,250088,296354,92765,92767,48930,99863,122866,158521,204314,209125,209486,274419,289556,169265,293450,157760,203515,48981,48941,48932,48935,79377,133339,135771,141296,49024,220309,161405,102277,49023,200024,207110,113780,147930,147931,196859,203384,206272,208945,208946,211572,270006,270007,48933,97139,147934,147933,148914)
get_typs (Datasource=, Time=0ms, Records=13) in E:\inetpub\wwwroot\category_sidenav_new.cfm @ 14:56:08.008
select distinct typ from getproducts1 where dept='Smith & Wesson' and brand='SMITH AND WESSON' group by typ order by sort_position
get_details (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\category_sidenav_new.cfm @ 14:56:08.008
select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Smith & Wesson' and typ='Archive Gun Collection' and subtyp_1='EMPTY' and site = 'sportsman'
get_details (Datasource=celerantsql, Time=16ms, Records=1) in E:\inetpub\wwwroot\category_sidenav_new.cfm @ 14:56:08.008
select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Smith & Wesson' and typ='Bodyguard 380' and subtyp_1='EMPTY' and site = 'sportsman'
get_details (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\category_sidenav_new.cfm @ 14:56:08.008
select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Smith & Wesson' and typ='Factory Magazines' and subtyp_1='EMPTY' and site = 'sportsman'
get_details (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\category_sidenav_new.cfm @ 14:56:08.008
select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Smith & Wesson' and typ='M&P Series' and subtyp_1='EMPTY' and site = 'sportsman'
get_details (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\category_sidenav_new.cfm @ 14:56:08.008
select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Smith & Wesson' and typ='S&W 1911 Series' and subtyp_1='EMPTY' and site = 'sportsman'
get_details (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\category_sidenav_new.cfm @ 14:56:08.008
select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Smith & Wesson' and typ='S&W Law Enforcement' and subtyp_1='EMPTY' and site = 'sportsman'
get_details (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\category_sidenav_new.cfm @ 14:56:08.008
select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Smith & Wesson' and typ='S&W Pistols' and subtyp_1='EMPTY' and site = 'sportsman'
get_details (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\category_sidenav_new.cfm @ 14:56:08.008
select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Smith & Wesson' and typ='S&W Revolvers' and subtyp_1='EMPTY' and site = 'sportsman'
get_details (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\category_sidenav_new.cfm @ 14:56:08.008
select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Smith & Wesson' and typ='S&W Rifles' and subtyp_1='EMPTY' and site = 'sportsman'
get_details (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\category_sidenav_new.cfm @ 14:56:08.008
select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Smith & Wesson' and typ='S&W Rimfire Pistols' and subtyp_1='EMPTY' and site = 'sportsman'
get_details (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\category_sidenav_new.cfm @ 14:56:08.008
select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Smith & Wesson' and typ='S&W Shotguns' and subtyp_1='EMPTY' and site = 'sportsman'
get_details (Datasource=celerantsql, Time=15ms, Records=1) in E:\inetpub\wwwroot\category_sidenav_new.cfm @ 14:56:08.008
select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Smith & Wesson' and typ='SD Series' and subtyp_1='EMPTY' and site = 'sportsman'
Getweburl (Datasource=celerantsql, Time=0ms, Records=0) in E:\inetpub\wwwroot\category.cfm @ 14:56:08.008
select web_url from tb_web_taxonomy with (nolock) where dept='' and site = 'sportsman'
check_qoh (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\category_product_display.cfm @ 14:56:08.008
select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 266676 and e.store_id = 10 
			group by a.style_id, e.qc
check_ss_qoh (Datasource=celerantsql, Time=0ms, Records=0) in C:\inetpub\wwwroot\includes\dropship.cfm @ 14:56:08.008
select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 266676 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = BERETTA
Parameter #2(cf_sql_varchar) = GLOCK
Parameter #3(cf_sql_varchar) = RUGER
Parameter #4(cf_sql_varchar) = SMITH AND WESSON
Parameter #5(cf_sql_varchar) = LEUPOLD
Parameter #6(cf_sql_varchar) = SPRINGFIELD
Parameter #7(cf_sql_varchar) = THOMPSON CENTER
Parameter #8(cf_sql_varchar) = TIKKA
Parameter #9(cf_sql_varchar) = WALTHER

bulk_price (Datasource=, Time=0ms, Records=0) in E:\inetpub\wwwroot\category_product_display.cfm @ 14:56:08.008
select * from bulkitems where bulk_id = ? and site is NULL
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 266676

get_term_sale_info (Datasource=celerantsql, Time=17ms, Records=0) in C:\inetpub\wwwroot\includes\qry_term_sale_price.cfm @ 14:56:08.008
select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:56:08' and
end_date >= 'May 20, 2024 14:56:08'
and store_id=10 and style_id=266676
get_promos (Datasource=celerantsql, Time=0ms, Records=0) in C:\inetpub\wwwroot\includes\qry_mfg_promo_price.cfm @ 14:56:08.008
SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 266676 
and (a.start_date<= 'May 20, 2024 14:56:08' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:56:08'
order by a.promo_id desc
get_reviews (Datasource=celerantsql, Time=0ms, Records=0) in E:\inetpub\wwwroot\category_product_display.cfm @ 14:56:08.008
select * from tb_product_reviews with (nolock) where style_id=266676  and status='A' and site = 'sportsman'
get_reviews_average (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\category_product_display.cfm @ 14:56:08.008
select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=266676 and status='A' and site = 'sportsman'
check_qoh (Datasource=celerantsql, Time=15ms, Records=1) in E:\inetpub\wwwroot\category_product_display.cfm @ 14:56:08.008
select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 100197 and e.store_id = 10 
			group by a.style_id, e.qc
check_ss_qoh (Datasource=celerantsql, Time=0ms, Records=0) in C:\inetpub\wwwroot\includes\dropship.cfm @ 14:56:08.008
select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 100197 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = BERETTA
Parameter #2(cf_sql_varchar) = GLOCK
Parameter #3(cf_sql_varchar) = RUGER
Parameter #4(cf_sql_varchar) = SMITH AND WESSON
Parameter #5(cf_sql_varchar) = LEUPOLD
Parameter #6(cf_sql_varchar) = SPRINGFIELD
Parameter #7(cf_sql_varchar) = THOMPSON CENTER
Parameter #8(cf_sql_varchar) = TIKKA
Parameter #9(cf_sql_varchar) = WALTHER

bulk_price (Datasource=, Time=0ms, Records=0) in E:\inetpub\wwwroot\category_product_display.cfm @ 14:56:08.008
select * from bulkitems where bulk_id = ? and site is NULL
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 100197

get_term_sale_info (Datasource=celerantsql, Time=0ms, Records=0) in C:\inetpub\wwwroot\includes\qry_term_sale_price.cfm @ 14:56:08.008
select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:56:08' and
end_date >= 'May 20, 2024 14:56:08'
and store_id=10 and style_id=100197
get_promos (Datasource=celerantsql, Time=0ms, Records=0) in C:\inetpub\wwwroot\includes\qry_mfg_promo_price.cfm @ 14:56:08.008
SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 100197 
and (a.start_date<= 'May 20, 2024 14:56:08' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:56:08'
order by a.promo_id desc
get_reviews (Datasource=celerantsql, Time=0ms, Records=4) in E:\inetpub\wwwroot\category_product_display.cfm @ 14:56:08.008
select * from tb_product_reviews with (nolock) where style_id=100197  and status='A' and site = 'sportsman'
get_reviews_average (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\category_product_display.cfm @ 14:56:08.008
select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=100197 and status='A' and site = 'sportsman'
check_qoh (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\category_product_display.cfm @ 14:56:08.008
select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 212059 and e.store_id = 10 
			group by a.style_id, e.qc
check_ss_qoh (Datasource=celerantsql, Time=47ms, Records=0) in C:\inetpub\wwwroot\includes\dropship.cfm @ 14:56:09.009
select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 212059 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = BERETTA
Parameter #2(cf_sql_varchar) = GLOCK
Parameter #3(cf_sql_varchar) = RUGER
Parameter #4(cf_sql_varchar) = SMITH AND WESSON
Parameter #5(cf_sql_varchar) = LEUPOLD
Parameter #6(cf_sql_varchar) = SPRINGFIELD
Parameter #7(cf_sql_varchar) = THOMPSON CENTER
Parameter #8(cf_sql_varchar) = TIKKA
Parameter #9(cf_sql_varchar) = WALTHER

bulk_price (Datasource=, Time=0ms, Records=0) in E:\inetpub\wwwroot\category_product_display.cfm @ 14:56:09.009
select * from bulkitems where bulk_id = ? and site is NULL
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 212059

get_term_sale_info (Datasource=celerantsql, Time=0ms, Records=0) in C:\inetpub\wwwroot\includes\qry_term_sale_price.cfm @ 14:56:09.009
select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:56:09' and
end_date >= 'May 20, 2024 14:56:09'
and store_id=10 and style_id=212059
get_promos (Datasource=celerantsql, Time=0ms, Records=0) in C:\inetpub\wwwroot\includes\qry_mfg_promo_price.cfm @ 14:56:09.009
SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 212059 
and (a.start_date<= 'May 20, 2024 14:56:09' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:56:09'
order by a.promo_id desc
get_reviews (Datasource=celerantsql, Time=0ms, Records=0) in E:\inetpub\wwwroot\category_product_display.cfm @ 14:56:09.009
select * from tb_product_reviews with (nolock) where style_id=212059  and status='A' and site = 'sportsman'
get_reviews_average (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\category_product_display.cfm @ 14:56:09.009
select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=212059 and status='A' and site = 'sportsman'
check_qoh (Datasource=celerantsql, Time=17ms, Records=1) in E:\inetpub\wwwroot\category_product_display.cfm @ 14:56:09.009
select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 218303 and e.store_id = 10 
			group by a.style_id, e.qc
check_ss_qoh (Datasource=celerantsql, Time=31ms, Records=0) in C:\inetpub\wwwroot\includes\dropship.cfm @ 14:56:09.009
select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 218303 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = BERETTA
Parameter #2(cf_sql_varchar) = GLOCK
Parameter #3(cf_sql_varchar) = RUGER
Parameter #4(cf_sql_varchar) = SMITH AND WESSON
Parameter #5(cf_sql_varchar) = LEUPOLD
Parameter #6(cf_sql_varchar) = SPRINGFIELD
Parameter #7(cf_sql_varchar) = THOMPSON CENTER
Parameter #8(cf_sql_varchar) = TIKKA
Parameter #9(cf_sql_varchar) = WALTHER

bulk_price (Datasource=, Time=0ms, Records=0) in E:\inetpub\wwwroot\category_product_display.cfm @ 14:56:09.009
select * from bulkitems where bulk_id = ? and site is NULL
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 218303

get_term_sale_info (Datasource=celerantsql, Time=0ms, Records=0) in C:\inetpub\wwwroot\includes\qry_term_sale_price.cfm @ 14:56:09.009
select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:56:09' and
end_date >= 'May 20, 2024 14:56:09'
and store_id=10 and style_id=218303
get_promos (Datasource=celerantsql, Time=16ms, Records=0) in C:\inetpub\wwwroot\includes\qry_mfg_promo_price.cfm @ 14:56:09.009
SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 218303 
and (a.start_date<= 'May 20, 2024 14:56:09' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:56:09'
order by a.promo_id desc
get_reviews (Datasource=celerantsql, Time=0ms, Records=0) in E:\inetpub\wwwroot\category_product_display.cfm @ 14:56:09.009
select * from tb_product_reviews with (nolock) where style_id=218303  and status='A' and site = 'sportsman'
get_reviews_average (Datasource=celerantsql, Time=15ms, Records=1) in E:\inetpub\wwwroot\category_product_display.cfm @ 14:56:09.009
select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=218303 and status='A' and site = 'sportsman'
check_qoh (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\category_product_display.cfm @ 14:56:09.009
select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 218304 and e.store_id = 10 
			group by a.style_id, e.qc
check_ss_qoh (Datasource=celerantsql, Time=15ms, Records=0) in C:\inetpub\wwwroot\includes\dropship.cfm @ 14:56:09.009
select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 218304 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = BERETTA
Parameter #2(cf_sql_varchar) = GLOCK
Parameter #3(cf_sql_varchar) = RUGER
Parameter #4(cf_sql_varchar) = SMITH AND WESSON
Parameter #5(cf_sql_varchar) = LEUPOLD
Parameter #6(cf_sql_varchar) = SPRINGFIELD
Parameter #7(cf_sql_varchar) = THOMPSON CENTER
Parameter #8(cf_sql_varchar) = TIKKA
Parameter #9(cf_sql_varchar) = WALTHER

bulk_price (Datasource=, Time=0ms, Records=0) in E:\inetpub\wwwroot\category_product_display.cfm @ 14:56:09.009
select * from bulkitems where bulk_id = ? and site is NULL
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 218304

get_term_sale_info (Datasource=celerantsql, Time=16ms, Records=0) in C:\inetpub\wwwroot\includes\qry_term_sale_price.cfm @ 14:56:09.009
select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:56:09' and
end_date >= 'May 20, 2024 14:56:09'
and store_id=10 and style_id=218304
get_promos (Datasource=celerantsql, Time=0ms, Records=0) in C:\inetpub\wwwroot\includes\qry_mfg_promo_price.cfm @ 14:56:09.009
SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 218304 
and (a.start_date<= 'May 20, 2024 14:56:09' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:56:09'
order by a.promo_id desc
get_reviews (Datasource=celerantsql, Time=0ms, Records=0) in E:\inetpub\wwwroot\category_product_display.cfm @ 14:56:09.009
select * from tb_product_reviews with (nolock) where style_id=218304  and status='A' and site = 'sportsman'
get_reviews_average (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\category_product_display.cfm @ 14:56:09.009
select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=218304 and status='A' and site = 'sportsman'
check_qoh (Datasource=celerantsql, Time=16ms, Records=1) in E:\inetpub\wwwroot\category_product_display.cfm @ 14:56:09.009
select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 263845 and e.store_id = 10 
			group by a.style_id, e.qc
check_ss_qoh (Datasource=celerantsql, Time=16ms, Records=0) in C:\inetpub\wwwroot\includes\dropship.cfm @ 14:56:09.009
select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 263845 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = BERETTA
Parameter #2(cf_sql_varchar) = GLOCK
Parameter #3(cf_sql_varchar) = RUGER
Parameter #4(cf_sql_varchar) = SMITH AND WESSON
Parameter #5(cf_sql_varchar) = LEUPOLD
Parameter #6(cf_sql_varchar) = SPRINGFIELD
Parameter #7(cf_sql_varchar) = THOMPSON CENTER
Parameter #8(cf_sql_varchar) = TIKKA
Parameter #9(cf_sql_varchar) = WALTHER

bulk_price (Datasource=, Time=0ms, Records=0) in E:\inetpub\wwwroot\category_product_display.cfm @ 14:56:09.009
select * from bulkitems where bulk_id = ? and site is NULL
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 263845

get_term_sale_info (Datasource=celerantsql, Time=0ms, Records=0) in C:\inetpub\wwwroot\includes\qry_term_sale_price.cfm @ 14:56:09.009
select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:56:09' and
end_date >= 'May 20, 2024 14:56:09'
and store_id=10 and style_id=263845
get_promos (Datasource=celerantsql, Time=15ms, Records=0) in C:\inetpub\wwwroot\includes\qry_mfg_promo_price.cfm @ 14:56:09.009
SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 263845 
and (a.start_date<= 'May 20, 2024 14:56:09' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:56:09'
order by a.promo_id desc
get_reviews (Datasource=celerantsql, Time=0ms, Records=0) in E:\inetpub\wwwroot\category_product_display.cfm @ 14:56:09.009
select * from tb_product_reviews with (nolock) where style_id=263845  and status='A' and site = 'sportsman'
get_reviews_average (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\category_product_display.cfm @ 14:56:09.009
select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=263845 and status='A' and site = 'sportsman'
check_qoh (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\category_product_display.cfm @ 14:56:09.009
select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 48924 and e.store_id = 10 
			group by a.style_id, e.qc
check_ss_qoh (Datasource=celerantsql, Time=0ms, Records=0) in C:\inetpub\wwwroot\includes\dropship.cfm @ 14:56:09.009
select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 48924 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = BERETTA
Parameter #2(cf_sql_varchar) = GLOCK
Parameter #3(cf_sql_varchar) = RUGER
Parameter #4(cf_sql_varchar) = SMITH AND WESSON
Parameter #5(cf_sql_varchar) = LEUPOLD
Parameter #6(cf_sql_varchar) = SPRINGFIELD
Parameter #7(cf_sql_varchar) = THOMPSON CENTER
Parameter #8(cf_sql_varchar) = TIKKA
Parameter #9(cf_sql_varchar) = WALTHER

bulk_price (Datasource=, Time=0ms, Records=0) in E:\inetpub\wwwroot\category_product_display.cfm @ 14:56:09.009
select * from bulkitems where bulk_id = ? and site is NULL
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 48924

get_term_sale_info (Datasource=celerantsql, Time=16ms, Records=1) in C:\inetpub\wwwroot\includes\qry_term_sale_price.cfm @ 14:56:09.009
select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:56:09' and
end_date >= 'May 20, 2024 14:56:09'
and store_id=10 and style_id=48924
get_promos (Datasource=celerantsql, Time=0ms, Records=0) in C:\inetpub\wwwroot\includes\qry_mfg_promo_price.cfm @ 14:56:09.009
SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 48924 
and (a.start_date<= 'May 20, 2024 14:56:09' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:56:09'
order by a.promo_id desc
get_reviews (Datasource=celerantsql, Time=0ms, Records=0) in E:\inetpub\wwwroot\category_product_display.cfm @ 14:56:09.009
select * from tb_product_reviews with (nolock) where style_id=48924  and status='A' and site = 'sportsman'
get_reviews_average (Datasource=celerantsql, Time=16ms, Records=1) in E:\inetpub\wwwroot\category_product_display.cfm @ 14:56:09.009
select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=48924 and status='A' and site = 'sportsman'
check_qoh (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\category_product_display.cfm @ 14:56:09.009
select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 172794 and e.store_id = 10 
			group by a.style_id, e.qc
check_ss_qoh (Datasource=celerantsql, Time=0ms, Records=0) in C:\inetpub\wwwroot\includes\dropship.cfm @ 14:56:09.009
select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 172794 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = BERETTA
Parameter #2(cf_sql_varchar) = GLOCK
Parameter #3(cf_sql_varchar) = RUGER
Parameter #4(cf_sql_varchar) = SMITH AND WESSON
Parameter #5(cf_sql_varchar) = LEUPOLD
Parameter #6(cf_sql_varchar) = SPRINGFIELD
Parameter #7(cf_sql_varchar) = THOMPSON CENTER
Parameter #8(cf_sql_varchar) = TIKKA
Parameter #9(cf_sql_varchar) = WALTHER

bulk_price (Datasource=, Time=0ms, Records=0) in E:\inetpub\wwwroot\category_product_display.cfm @ 14:56:09.009
select * from bulkitems where bulk_id = ? and site is NULL
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 172794

get_term_sale_info (Datasource=celerantsql, Time=15ms, Records=0) in C:\inetpub\wwwroot\includes\qry_term_sale_price.cfm @ 14:56:09.009
select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:56:09' and
end_date >= 'May 20, 2024 14:56:09'
and store_id=10 and style_id=172794
get_promos (Datasource=celerantsql, Time=0ms, Records=0) in C:\inetpub\wwwroot\includes\qry_mfg_promo_price.cfm @ 14:56:09.009
SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 172794 
and (a.start_date<= 'May 20, 2024 14:56:09' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:56:09'
order by a.promo_id desc
get_reviews (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\category_product_display.cfm @ 14:56:09.009
select * from tb_product_reviews with (nolock) where style_id=172794  and status='A' and site = 'sportsman'
get_reviews_average (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\category_product_display.cfm @ 14:56:09.009
select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=172794 and status='A' and site = 'sportsman'
check_qoh (Datasource=celerantsql, Time=16ms, Records=1) in E:\inetpub\wwwroot\category_product_display.cfm @ 14:56:09.009
select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 266101 and e.store_id = 10 
			group by a.style_id, e.qc
check_ss_qoh (Datasource=celerantsql, Time=0ms, Records=0) in C:\inetpub\wwwroot\includes\dropship.cfm @ 14:56:09.009
select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 266101 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = BERETTA
Parameter #2(cf_sql_varchar) = GLOCK
Parameter #3(cf_sql_varchar) = RUGER
Parameter #4(cf_sql_varchar) = SMITH AND WESSON
Parameter #5(cf_sql_varchar) = LEUPOLD
Parameter #6(cf_sql_varchar) = SPRINGFIELD
Parameter #7(cf_sql_varchar) = THOMPSON CENTER
Parameter #8(cf_sql_varchar) = TIKKA
Parameter #9(cf_sql_varchar) = WALTHER

bulk_price (Datasource=, Time=0ms, Records=0) in E:\inetpub\wwwroot\category_product_display.cfm @ 14:56:09.009
select * from bulkitems where bulk_id = ? and site is NULL
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 266101

get_term_sale_info (Datasource=celerantsql, Time=0ms, Records=0) in C:\inetpub\wwwroot\includes\qry_term_sale_price.cfm @ 14:56:09.009
select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:56:09' and
end_date >= 'May 20, 2024 14:56:09'
and store_id=10 and style_id=266101
get_promos (Datasource=celerantsql, Time=17ms, Records=0) in C:\inetpub\wwwroot\includes\qry_mfg_promo_price.cfm @ 14:56:09.009
SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 266101 
and (a.start_date<= 'May 20, 2024 14:56:09' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:56:09'
order by a.promo_id desc
get_reviews (Datasource=celerantsql, Time=0ms, Records=0) in E:\inetpub\wwwroot\category_product_display.cfm @ 14:56:09.009
select * from tb_product_reviews with (nolock) where style_id=266101  and status='A' and site = 'sportsman'
get_reviews_average (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\category_product_display.cfm @ 14:56:09.009
select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=266101 and status='A' and site = 'sportsman'
check_qoh (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\category_product_display.cfm @ 14:56:09.009
select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 135600 and e.store_id = 10 
			group by a.style_id, e.qc
check_ss_qoh (Datasource=celerantsql, Time=0ms, Records=0) in C:\inetpub\wwwroot\includes\dropship.cfm @ 14:56:09.009
select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 135600 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = BERETTA
Parameter #2(cf_sql_varchar) = GLOCK
Parameter #3(cf_sql_varchar) = RUGER
Parameter #4(cf_sql_varchar) = SMITH AND WESSON
Parameter #5(cf_sql_varchar) = LEUPOLD
Parameter #6(cf_sql_varchar) = SPRINGFIELD
Parameter #7(cf_sql_varchar) = THOMPSON CENTER
Parameter #8(cf_sql_varchar) = TIKKA
Parameter #9(cf_sql_varchar) = WALTHER

bulk_price (Datasource=, Time=0ms, Records=0) in E:\inetpub\wwwroot\category_product_display.cfm @ 14:56:09.009
select * from bulkitems where bulk_id = ? and site is NULL
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 135600

get_term_sale_info (Datasource=celerantsql, Time=0ms, Records=0) in C:\inetpub\wwwroot\includes\qry_term_sale_price.cfm @ 14:56:09.009
select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:56:09' and
end_date >= 'May 20, 2024 14:56:09'
and store_id=10 and style_id=135600
get_promos (Datasource=celerantsql, Time=15ms, Records=0) in C:\inetpub\wwwroot\includes\qry_mfg_promo_price.cfm @ 14:56:09.009
SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 135600 
and (a.start_date<= 'May 20, 2024 14:56:09' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:56:09'
order by a.promo_id desc
get_reviews (Datasource=celerantsql, Time=0ms, Records=3) in E:\inetpub\wwwroot\category_product_display.cfm @ 14:56:09.009
select * from tb_product_reviews with (nolock) where style_id=135600  and status='A' and site = 'sportsman'
get_reviews_average (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\category_product_display.cfm @ 14:56:09.009
select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=135600 and status='A' and site = 'sportsman'
check_qoh (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\category_product_display.cfm @ 14:56:09.009
select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 142979 and e.store_id = 10 
			group by a.style_id, e.qc
check_ss_qoh (Datasource=celerantsql, Time=0ms, Records=0) in C:\inetpub\wwwroot\includes\dropship.cfm @ 14:56:09.009
select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 142979 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = BERETTA
Parameter #2(cf_sql_varchar) = GLOCK
Parameter #3(cf_sql_varchar) = RUGER
Parameter #4(cf_sql_varchar) = SMITH AND WESSON
Parameter #5(cf_sql_varchar) = LEUPOLD
Parameter #6(cf_sql_varchar) = SPRINGFIELD
Parameter #7(cf_sql_varchar) = THOMPSON CENTER
Parameter #8(cf_sql_varchar) = TIKKA
Parameter #9(cf_sql_varchar) = WALTHER

bulk_price (Datasource=, Time=0ms, Records=0) in E:\inetpub\wwwroot\category_product_display.cfm @ 14:56:09.009
select * from bulkitems where bulk_id = ? and site is NULL
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 142979

get_term_sale_info (Datasource=celerantsql, Time=17ms, Records=0) in C:\inetpub\wwwroot\includes\qry_term_sale_price.cfm @ 14:56:09.009
select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:56:09' and
end_date >= 'May 20, 2024 14:56:09'
and store_id=10 and style_id=142979
get_promos (Datasource=celerantsql, Time=7ms, Records=0) in C:\inetpub\wwwroot\includes\qry_mfg_promo_price.cfm @ 14:56:09.009
SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 142979 
and (a.start_date<= 'May 20, 2024 14:56:09' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:56:09'
order by a.promo_id desc
get_reviews (Datasource=celerantsql, Time=1ms, Records=0) in E:\inetpub\wwwroot\category_product_display.cfm @ 14:56:09.009
select * from tb_product_reviews with (nolock) where style_id=142979  and status='A' and site = 'sportsman'
get_reviews_average (Datasource=celerantsql, Time=1ms, Records=1) in E:\inetpub\wwwroot\category_product_display.cfm @ 14:56:09.009
select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=142979 and status='A' and site = 'sportsman'
check_qoh (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\category_product_display.cfm @ 14:56:09.009
select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 143193 and e.store_id = 10 
			group by a.style_id, e.qc
check_ss_qoh (Datasource=celerantsql, Time=0ms, Records=0) in C:\inetpub\wwwroot\includes\dropship.cfm @ 14:56:09.009
select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 143193 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = BERETTA
Parameter #2(cf_sql_varchar) = GLOCK
Parameter #3(cf_sql_varchar) = RUGER
Parameter #4(cf_sql_varchar) = SMITH AND WESSON
Parameter #5(cf_sql_varchar) = LEUPOLD
Parameter #6(cf_sql_varchar) = SPRINGFIELD
Parameter #7(cf_sql_varchar) = THOMPSON CENTER
Parameter #8(cf_sql_varchar) = TIKKA
Parameter #9(cf_sql_varchar) = WALTHER

bulk_price (Datasource=, Time=0ms, Records=0) in E:\inetpub\wwwroot\category_product_display.cfm @ 14:56:09.009
select * from bulkitems where bulk_id = ? and site is NULL
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 143193

get_term_sale_info (Datasource=celerantsql, Time=0ms, Records=0) in C:\inetpub\wwwroot\includes\qry_term_sale_price.cfm @ 14:56:09.009
select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:56:09' and
end_date >= 'May 20, 2024 14:56:09'
and store_id=10 and style_id=143193
get_promos (Datasource=celerantsql, Time=16ms, Records=0) in C:\inetpub\wwwroot\includes\qry_mfg_promo_price.cfm @ 14:56:09.009
SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 143193 
and (a.start_date<= 'May 20, 2024 14:56:09' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:56:09'
order by a.promo_id desc
get_reviews (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\category_product_display.cfm @ 14:56:09.009
select * from tb_product_reviews with (nolock) where style_id=143193  and status='A' and site = 'sportsman'
get_reviews_average (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\category_product_display.cfm @ 14:56:09.009
select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=143193 and status='A' and site = 'sportsman'
check_qoh (Datasource=celerantsql, Time=16ms, Records=1) in E:\inetpub\wwwroot\category_product_display.cfm @ 14:56:09.009
select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 143674 and e.store_id = 10 
			group by a.style_id, e.qc
check_ss_qoh (Datasource=celerantsql, Time=0ms, Records=0) in C:\inetpub\wwwroot\includes\dropship.cfm @ 14:56:09.009
select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 143674 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = BERETTA
Parameter #2(cf_sql_varchar) = GLOCK
Parameter #3(cf_sql_varchar) = RUGER
Parameter #4(cf_sql_varchar) = SMITH AND WESSON
Parameter #5(cf_sql_varchar) = LEUPOLD
Parameter #6(cf_sql_varchar) = SPRINGFIELD
Parameter #7(cf_sql_varchar) = THOMPSON CENTER
Parameter #8(cf_sql_varchar) = TIKKA
Parameter #9(cf_sql_varchar) = WALTHER

bulk_price (Datasource=, Time=0ms, Records=0) in E:\inetpub\wwwroot\category_product_display.cfm @ 14:56:09.009
select * from bulkitems where bulk_id = ? and site is NULL
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 143674

get_term_sale_info (Datasource=celerantsql, Time=0ms, Records=0) in C:\inetpub\wwwroot\includes\qry_term_sale_price.cfm @ 14:56:09.009
select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:56:09' and
end_date >= 'May 20, 2024 14:56:09'
and store_id=10 and style_id=143674
get_promos (Datasource=celerantsql, Time=16ms, Records=0) in C:\inetpub\wwwroot\includes\qry_mfg_promo_price.cfm @ 14:56:09.009
SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 143674 
and (a.start_date<= 'May 20, 2024 14:56:09' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:56:09'
order by a.promo_id desc
get_reviews (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\category_product_display.cfm @ 14:56:09.009
select * from tb_product_reviews with (nolock) where style_id=143674  and status='A' and site = 'sportsman'
get_reviews_average (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\category_product_display.cfm @ 14:56:09.009
select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=143674 and status='A' and site = 'sportsman'
check_qoh (Datasource=celerantsql, Time=16ms, Records=1) in E:\inetpub\wwwroot\category_product_display.cfm @ 14:56:09.009
select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 143801 and e.store_id = 10 
			group by a.style_id, e.qc
check_ss_qoh (Datasource=celerantsql, Time=0ms, Records=0) in C:\inetpub\wwwroot\includes\dropship.cfm @ 14:56:09.009
select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 143801 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = BERETTA
Parameter #2(cf_sql_varchar) = GLOCK
Parameter #3(cf_sql_varchar) = RUGER
Parameter #4(cf_sql_varchar) = SMITH AND WESSON
Parameter #5(cf_sql_varchar) = LEUPOLD
Parameter #6(cf_sql_varchar) = SPRINGFIELD
Parameter #7(cf_sql_varchar) = THOMPSON CENTER
Parameter #8(cf_sql_varchar) = TIKKA
Parameter #9(cf_sql_varchar) = WALTHER

bulk_price (Datasource=, Time=0ms, Records=0) in E:\inetpub\wwwroot\category_product_display.cfm @ 14:56:09.009
select * from bulkitems where bulk_id = ? and site is NULL
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 143801

get_term_sale_info (Datasource=celerantsql, Time=0ms, Records=0) in C:\inetpub\wwwroot\includes\qry_term_sale_price.cfm @ 14:56:09.009
select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:56:09' and
end_date >= 'May 20, 2024 14:56:09'
and store_id=10 and style_id=143801
get_promos (Datasource=celerantsql, Time=16ms, Records=0) in C:\inetpub\wwwroot\includes\qry_mfg_promo_price.cfm @ 14:56:09.009
SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 143801 
and (a.start_date<= 'May 20, 2024 14:56:09' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:56:09'
order by a.promo_id desc
get_reviews (Datasource=celerantsql, Time=0ms, Records=0) in E:\inetpub\wwwroot\category_product_display.cfm @ 14:56:09.009
select * from tb_product_reviews with (nolock) where style_id=143801  and status='A' and site = 'sportsman'
get_reviews_average (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\category_product_display.cfm @ 14:56:09.009
select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=143801 and status='A' and site = 'sportsman'
check_qoh (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\category_product_display.cfm @ 14:56:09.009
select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 185556 and e.store_id = 10 
			group by a.style_id, e.qc
check_ss_qoh (Datasource=celerantsql, Time=16ms, Records=0) in C:\inetpub\wwwroot\includes\dropship.cfm @ 14:56:09.009
select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 185556 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = BERETTA
Parameter #2(cf_sql_varchar) = GLOCK
Parameter #3(cf_sql_varchar) = RUGER
Parameter #4(cf_sql_varchar) = SMITH AND WESSON
Parameter #5(cf_sql_varchar) = LEUPOLD
Parameter #6(cf_sql_varchar) = SPRINGFIELD
Parameter #7(cf_sql_varchar) = THOMPSON CENTER
Parameter #8(cf_sql_varchar) = TIKKA
Parameter #9(cf_sql_varchar) = WALTHER

bulk_price (Datasource=, Time=0ms, Records=0) in E:\inetpub\wwwroot\category_product_display.cfm @ 14:56:09.009
select * from bulkitems where bulk_id = ? and site is NULL
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 185556

get_term_sale_info (Datasource=celerantsql, Time=0ms, Records=0) in C:\inetpub\wwwroot\includes\qry_term_sale_price.cfm @ 14:56:09.009
select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:56:09' and
end_date >= 'May 20, 2024 14:56:09'
and store_id=10 and style_id=185556
get_promos (Datasource=celerantsql, Time=0ms, Records=0) in C:\inetpub\wwwroot\includes\qry_mfg_promo_price.cfm @ 14:56:09.009
SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 185556 
and (a.start_date<= 'May 20, 2024 14:56:09' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:56:09'
order by a.promo_id desc
get_reviews (Datasource=celerantsql, Time=15ms, Records=0) in E:\inetpub\wwwroot\category_product_display.cfm @ 14:56:09.009
select * from tb_product_reviews with (nolock) where style_id=185556  and status='A' and site = 'sportsman'
get_reviews_average (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\category_product_display.cfm @ 14:56:09.009
select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=185556 and status='A' and site = 'sportsman'
check_qoh (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\category_product_display.cfm @ 14:56:09.009
select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 266669 and e.store_id = 10 
			group by a.style_id, e.qc
check_ss_qoh (Datasource=celerantsql, Time=0ms, Records=0) in C:\inetpub\wwwroot\includes\dropship.cfm @ 14:56:09.009
select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 266669 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = BERETTA
Parameter #2(cf_sql_varchar) = GLOCK
Parameter #3(cf_sql_varchar) = RUGER
Parameter #4(cf_sql_varchar) = SMITH AND WESSON
Parameter #5(cf_sql_varchar) = LEUPOLD
Parameter #6(cf_sql_varchar) = SPRINGFIELD
Parameter #7(cf_sql_varchar) = THOMPSON CENTER
Parameter #8(cf_sql_varchar) = TIKKA
Parameter #9(cf_sql_varchar) = WALTHER

bulk_price (Datasource=, Time=0ms, Records=0) in E:\inetpub\wwwroot\category_product_display.cfm @ 14:56:09.009
select * from bulkitems where bulk_id = ? and site is NULL
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 266669

get_term_sale_info (Datasource=celerantsql, Time=16ms, Records=0) in C:\inetpub\wwwroot\includes\qry_term_sale_price.cfm @ 14:56:09.009
select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:56:09' and
end_date >= 'May 20, 2024 14:56:09'
and store_id=10 and style_id=266669
get_promos (Datasource=celerantsql, Time=0ms, Records=0) in C:\inetpub\wwwroot\includes\qry_mfg_promo_price.cfm @ 14:56:09.009
SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 266669 
and (a.start_date<= 'May 20, 2024 14:56:09' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:56:09'
order by a.promo_id desc
get_reviews (Datasource=celerantsql, Time=0ms, Records=0) in E:\inetpub\wwwroot\category_product_display.cfm @ 14:56:09.009
select * from tb_product_reviews with (nolock) where style_id=266669  and status='A' and site = 'sportsman'
get_reviews_average (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\category_product_display.cfm @ 14:56:09.009
select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=266669 and status='A' and site = 'sportsman'
check_qoh (Datasource=celerantsql, Time=16ms, Records=1) in E:\inetpub\wwwroot\category_product_display.cfm @ 14:56:09.009
select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 269839 and e.store_id = 10 
			group by a.style_id, e.qc
check_ss_qoh (Datasource=celerantsql, Time=0ms, Records=0) in C:\inetpub\wwwroot\includes\dropship.cfm @ 14:56:09.009
select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 269839 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = BERETTA
Parameter #2(cf_sql_varchar) = GLOCK
Parameter #3(cf_sql_varchar) = RUGER
Parameter #4(cf_sql_varchar) = SMITH AND WESSON
Parameter #5(cf_sql_varchar) = LEUPOLD
Parameter #6(cf_sql_varchar) = SPRINGFIELD
Parameter #7(cf_sql_varchar) = THOMPSON CENTER
Parameter #8(cf_sql_varchar) = TIKKA
Parameter #9(cf_sql_varchar) = WALTHER

bulk_price (Datasource=, Time=0ms, Records=0) in E:\inetpub\wwwroot\category_product_display.cfm @ 14:56:09.009
select * from bulkitems where bulk_id = ? and site is NULL
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 269839

get_term_sale_info (Datasource=celerantsql, Time=0ms, Records=0) in C:\inetpub\wwwroot\includes\qry_term_sale_price.cfm @ 14:56:09.009
select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:56:09' and
end_date >= 'May 20, 2024 14:56:09'
and store_id=10 and style_id=269839
get_promos (Datasource=celerantsql, Time=16ms, Records=0) in C:\inetpub\wwwroot\includes\qry_mfg_promo_price.cfm @ 14:56:09.009
SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 269839 
and (a.start_date<= 'May 20, 2024 14:56:09' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:56:09'
order by a.promo_id desc
get_reviews (Datasource=celerantsql, Time=0ms, Records=0) in E:\inetpub\wwwroot\category_product_display.cfm @ 14:56:09.009
select * from tb_product_reviews with (nolock) where style_id=269839  and status='A' and site = 'sportsman'
get_reviews_average (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\category_product_display.cfm @ 14:56:09.009
select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=269839 and status='A' and site = 'sportsman'
check_qoh (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\category_product_display.cfm @ 14:56:09.009
select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 48864 and e.store_id = 10 
			group by a.style_id, e.qc
check_ss_qoh (Datasource=celerantsql, Time=16ms, Records=0) in C:\inetpub\wwwroot\includes\dropship.cfm @ 14:56:09.009
select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 48864 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = BERETTA
Parameter #2(cf_sql_varchar) = GLOCK
Parameter #3(cf_sql_varchar) = RUGER
Parameter #4(cf_sql_varchar) = SMITH AND WESSON
Parameter #5(cf_sql_varchar) = LEUPOLD
Parameter #6(cf_sql_varchar) = SPRINGFIELD
Parameter #7(cf_sql_varchar) = THOMPSON CENTER
Parameter #8(cf_sql_varchar) = TIKKA
Parameter #9(cf_sql_varchar) = WALTHER

bulk_price (Datasource=, Time=0ms, Records=0) in E:\inetpub\wwwroot\category_product_display.cfm @ 14:56:09.009
select * from bulkitems where bulk_id = ? and site is NULL
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 48864

get_term_sale_info (Datasource=celerantsql, Time=16ms, Records=0) in C:\inetpub\wwwroot\includes\qry_term_sale_price.cfm @ 14:56:09.009
select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:56:09' and
end_date >= 'May 20, 2024 14:56:09'
and store_id=10 and style_id=48864
get_promos (Datasource=celerantsql, Time=0ms, Records=0) in C:\inetpub\wwwroot\includes\qry_mfg_promo_price.cfm @ 14:56:09.009
SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 48864 
and (a.start_date<= 'May 20, 2024 14:56:09' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:56:09'
order by a.promo_id desc
get_reviews (Datasource=celerantsql, Time=0ms, Records=0) in E:\inetpub\wwwroot\category_product_display.cfm @ 14:56:09.009
select * from tb_product_reviews with (nolock) where style_id=48864  and status='A' and site = 'sportsman'
get_reviews_average (Datasource=celerantsql, Time=15ms, Records=1) in E:\inetpub\wwwroot\category_product_display.cfm @ 14:56:09.009
select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=48864 and status='A' and site = 'sportsman'

Scope Variables

Application Variables:
acceptorid=011668467
accountid=1027380
accounttoken=64BB6980FDEAF842266AC866F250CA9877FF24AE92795FB9BE490EAF527645FC4E54DC01
adminurl=https://www.sportsmansoutdoorsuperstore.com/web_admin/products/menu.cfm?style_id=
applicationname=SOS
bannerurl=https://www.sportsmansoutdoorsuperstore.com/images/banners/
ccprocessor=VANTIV
checkinventory=Struct (3)
companyname=Vance Outdoors
credova=Struct (5)
ds=celerantsql
enter_inscription=OFF
feedsdir=E:\inetpub\feeds\
forumemail=info@sportsmansoutdoorsuperstore.com
forumtitle=Sportsmans Outdoor Superstore
giftcardimgpath=file:///C:/websites/images/
giftcardpdfpath=E:\websites\giftcardPDF\
googlefeedproducttype=
homeurl=https://www.sportsmansoutdoorsuperstore.com/
hostedpagelink=https://transaction.hostedpayments.com/
iconurl=https://www.sportsmansoutdoorsuperstore.com/images/icons/
imagedir=E:\inetpub\images\
logdir=E:\inetpub\logs
metadesc=
metatags=
mydomain=https://www.sportsmansoutdoorsuperstore.com/
pagetitle=
picurl=https://www.sportsmansoutdoorsuperstore.com/images/
prodimgdir=E:\inetpub\prodimages\
prodimgurl=https://www.sportsmansoutdoorsuperstore.com/prodimages/
qoh_store=10
safety_stock=0
salesemail=sales@sportsmansoutdoorsuperstore.com
secureurl=https://www.sportsmansoutdoorsuperstore.com/
site=sportsman
tempmailport=25
tempmailserver=127.0.0.1
tokenurl=https://services.elementexpress.com/express.asmx
use_multi_buy=OFF
vantivurl=https://transaction.elementexpress.com/express.asmx
webadminurl=https://www.sportsmansoutdoorsuperstore.com/web_admin/
websitename=Sportsmans Outdoor Superstore

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=256
CERT_SECRETKEYSIZE=2048
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=C=US, O=Let's Encrypt, CN=R3
CERT_SERVER_SUBJECT=CN=www.sportsmansoutdoorsuperstore.com
CERT_SUBJECT=
CF_TEMPLATE_PATH=E:\inetpub\wwwroot\category.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=on
HTTPS_KEYSIZE=256
HTTPS_SECRETKEYSIZE=2048
HTTPS_SERVER_ISSUER=C=US, O=Let's Encrypt, CN=R3
HTTPS_SERVER_SUBJECT=CN=www.sportsmansoutdoorsuperstore.com
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close
HTTP_COOKIE=CFTOKEN=Z98olbwg5rxrj4kxa625akg5dpmaa354uo66g173yqvk4tox9o-ee4e16a37a9175ca-E994AB14-9E00-26DC-57DC0CDC4B6F2AFF; CFGLOBALS=urltoken%3DCFID%23%3D8512%26CFTOKEN%23%3Dee4e16a37a9175ca%2DE994AB14%2D9E00%2D26DC%2D57DC0CDC4B6F2AFF%23lastvisit%3D%7Bts%20%272024%2D05%2D20%2014%3A56%3A07%27%7D%23hitcount%3D89%23timecreated%3D%7Bts%20%272024%2D05%2D20%2014%3A55%3A18%27%7D%23cftoken%3Dee4e16a37a9175ca%2DE994AB14%2D9E00%2D26DC%2D57DC0CDC4B6F2AFF%23cfid%3D8512%23; CFID=Z98olbwg5rxrj4kxa625akg5dpmaa354uo66g173yqvk4tox9o-8512; CT_U=2359; PRD_U=124747%2C762; LAST_NAME=; USERNAME=; CUSTOMER_ID=; EMAIL=; PASSWORD=; FIRST_NAME=
HTTP_HOST=www.sportsmansoutdoorsuperstore.com
HTTP_REFERER=
HTTP_URL=/category.cfm/CurrentPage/13/sportsman/gifts-under-100/brand/SMITH%20AND%20WESSON/order_by/min_price%20desc
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=10.200.30.6
PATH_INFO=/CurrentPage/13/sportsman/gifts-under-100/brand/SMITH AND WESSON/order_by/min_price desc
PATH_TRANSLATED=E:\inetpub\wwwroot\category.cfm
QUERY_STRING=
REMOTE_ADDR=10.200.2.4
REMOTE_HOST=10.200.2.4
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/category.cfm
SERVER_NAME=www.sportsmansoutdoorsuperstore.com
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=

Client Variables:
cfid=8512
cftoken=ee4e16a37a9175ca-E994AB14-9E00-26DC-57DC0CDC4B6F2AFF
hitcount=89
lastvisit={ts '2024-05-20 14:56:07'}
timecreated={ts '2024-05-20 14:55:18'}
urltoken=CFID=8512&CFTOKEN=ee4e16a37a9175ca-E994AB14-9E00-26DC-57DC0CDC4B6F2AFF

Cookie Variables:
CFGLOBALS=urltoken=CFID#=8512&CFTOKEN#=ee4e16a37a9175ca-E994AB14-9E00-26DC-57DC0CDC4B6F2AFF#lastvisit={ts '2024-05-20 14:56:07'}#hitcount=89#timecreated={ts '2024-05-20 14:55:18'}#cftoken=ee4e16a37a9175ca-E994AB14-9E00-26DC-57DC0CDC4B6F2AFF#cfid=8512#
CFID=8512
CFTOKEN=ee4e16a37a9175ca-E994AB14-9E00-26DC-57DC0CDC4B6F2AFF
CT_U=2359
CUSTOMER_ID=
EMAIL=
FIRST_NAME=
LAST_NAME=
PASSWORD=
PRD_U=124747,762
USERNAME=

Form Fields:
RETURN_TO_PAGE=null

Request Parameters:
samesite_value=

Server Variables:
coldfusion=Struct (10)
os=Struct (5)
system=Struct (2)

Session Variables:
cfid=8512
cftoken=ee4e16a37a9175ca-E994AB14-9E00-26DC-57DC0CDC4B6F2AFF
cs=/category.cfm/CurrentPage/13/sportsman/gifts-under-100/brand/SMITH AND WESSON/order_by/min_price desc
displaycount=18
employeeloggedin=N
executed=YES
fflnote=
firearm_agreement=NO
imgarray=Array (0)
memberloggedin=N
pickupstore=10
prodtype=none
selected_ffl=NO
sessionid=SOS_8512_ee4e16a37a9175ca-E994AB14-9E00-26DC-57DC0CDC4B6F2AFF
strarray=Array (0)
urltoken=CFID=8512&CFTOKEN=ee4e16a37a9175ca-E994AB14-9E00-26DC-57DC0CDC4B6F2AFF

URL Parameters:
CLEARANCE=
CurrentPage=13
DEPT=
NAV_CHOOSER=
OF1=
OF10=
OF2=
OF3=
OF4=
OF5=
OF6=
PAGETYPE=
PRODTYPE=none
RETURN_TO_PAGE=null
SECTION=
SUBTYP_1=
SUBTYP_2=
SUBTYP_3=
TYP=
WEB_TAXONOMY_ID=
WHATSNEW=
brand=SMITH AND WESSON
order_by=min_price desc
sportsman=gifts-under-100
Debug Rendering Time: 0 ms